• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. G

    Best practice formula for TRUE condition

    Hello friends, I faced a situation where I was to check for a condition, and based on that condition I will be needed to fetch another value from the same data table. My choice was obvious VLOOKUP()..... But as expected the situation is not so kind hearted, now the new requirement is that I...
  2. G

    Shorten the AND() options

    Hello, How can I shorten this Basically it is the part of the longer formula
  3. G

    Count Max value (text+number) occurrences with filtering a specific part of text

    I'm having an excel column range of Text+Numbers (including blank cells) something like: 00EGB00-GE001 00EGB00-GE001 00EGB00-GE001 00EGB00-GE001 00EGB00-GE002 00EGB00-GE002 00EGB00-GE002 00EGB00-GE002 00EGD20-GD101 First what I need is to Count total number of similar values and I'm stuck...
  4. G

    MF Portfolio Tracker & Android

    Hope u all must be aware of problems faced in accessing Internet Data connections in Android. For example we have a MF portfolio tracker sheet in chandoo forums, the excel sheet auto fetches the data (text) from internet and updates everything in a particular sheet. But u can't fetch the same...
  5. G

    vlookup does not solve the purpose

    Hello, I am having a wonderfully huge list of values having lot of data like: head1 head2 ..... headX value1 value2..... valueX value1 value2..... valueX value3 value4..... valueX value1 value2..... valueX value3 value4..... valueX value3 value4..... valueX value1 value2..... valueX and the...
  6. G

    Extract a particualr part of text

    Dear friends, I'm stuck with a problem. We get datasheet (xls) file with data in single column but multiple rows, like: LATER 0 - 3.6 bar(g) 10-16840 MM 0.7 - 75 deg C What I need to do is to extract "0" i.e before - symbol.... and then extract 3.6, 16840, and 75 which comes after -...
Back
Top