• 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. B

    Extract text string from in between two _ ?

    Greetings all! I have a bunch of cells that are lists of filenames that all follow the same format: DFC_000094_AUST_bill.xls DFC_000095_BRAZ_bill.xls DFC_000096_CANA_bill.xls DFC_000097_CHIL_bill.xls I need to extract the four letter code that is in between the 2nd and 3rd "_" for each. AUST...
  2. B

    Return range from a Data Table based on Lookup Criteria

    I am trying to come up with a formula that will let me return an array of X cells beginning with the the 1st NON-ZERO value from a data table: ItemA:0|1|2|8 ItemB:9|0|3|6 ItemC:4|2|0|5 So, given the Item and say 3 cells, the formula Would return something like this: ItemA:1|2|8 ItemB:9|0|3...
  3. B

    Finding the Nth negative value

    Hopefully the forum can help me since I've been struggling with this for a few days and am losing my mind. I have a large range of automatically generated columns that report daily predicted inventory levels. These numbers can be positive, negative, or 0. Given a user supplied integer I...
Back
Top