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

    Filter group of records with sum not equal to zero

    Hi Jeffrey, The first formula works perfect. Thank You very much, this will be big time saver. Greatly appreciate your help. Ashvin
  2. A

    Filter group of records with sum not equal to zero

    Hi, How can I filter this spreadsheet so that I can only see the entries where the sum is not equal to zero. For example I would like to see rows 2 to 5 and 24 to 26 because the sum is not zero. I do not want see rows 6 to 23 and 27 to 37 because the sum is zero. I can filter by color if I color...
  3. A

    Trying to match rows in spreadsheet

    Thank You AIM, your formulae works perfect. Thanks for all your help.
  4. A

    Trying to match rows in spreadsheet

    Thank You Somendra, your formulae works perfect. Thank you very much!!!
  5. A

    Trying to match rows in spreadsheet

    Hi, I have spreadsheet that is about 1000 rows and I am trying to matched the rows. Here is examples of what I am trying to get. The amounts are sorted in ascending order. If amount matches, than I would want formulae to insert "Matched" otherwise "Not Matched". I tried using...
  6. A

    Data Validation with Uppercase

    Thank you very much Narayan. The second option works great. Thanks again, Ashvin
  7. A

    Data Validation with Uppercase

    Hi, I have cell that has data validation. I created list which has values from PA001 through PA600. The data validation works great but it will accept lower case letters like "Pa100" or "pa100". I need the cell to be in uppercase. Can this be done without using VBA. Can we combine the UPPER...
Back
Top