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

    Find blank cells between two non-blank cells in a particular row

    Thanks for responding bobhc! The problem with that is that there could be empty cells at the end of the range or beginning and they would not have left and came back. For example below if the range includes March 2013 back to September 2012...
  2. H

    Find blank cells between two non-blank cells in a particular row

    Hello all! I've been racking my brain for a few days on this one. I have a list of unique Member IDs in column A and the associated months that they have been members in columns B and beyond: Example: 123456789|||March_2013|||February_2013||| etc... In many instance people are members then...
  3. H

    IF a cell contains text and IF another cell equals a number

    Awesome. Thanks Luke!
  4. H

    IF a cell contains text and IF another cell equals a number

    Hello, I have a spreadsheet with 2 columns. Column 1 contains words and column 2 contains numbers. What I would like to do is write a query to say something like: If a cell in column 1 (well say a2 for example) contains text "diab" and a cell in column 2 (well say b2 for example) equals 1...
Back
Top