• 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, 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...
  2. 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...
  3. 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