Comparing cell content

C

Collcat

Thank You for the assistance.

I rearragnged my data on a hidden sheet like suggested and the formula
worked good.
Until I had some blank cells in my spreadsheet.

The formulas were counting/comparing the blanks and obviously th
sought after result was not correct.

So How do I get the formula to ignore blank cells?


Thanks
// Coolca
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide columns based on row values 2
Count Number of Unique Cells That Don't Have Certain Characters 0
Return BLANK is cell value sought is blank 13
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Drop down list control value in vba 2
Extracting data from database into separate sheets 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Using a vlookup to search multiple criteria for one result? 7

Top