Solved: Array Countif that will ignore Formula Blanks

[JimS]

Is there away to get the following formula to ignore formulas that result with blank cells in the Range?

{=MAX(COUNTIF(Range,Range))}

The Range is made up of formulas that can result in blanks - I would like the above formula ({=MAX(COUNTIF(Range,Range))}) to ignore any cells that formula results with a blank.


Thanks for any help...

JimS

[Bob Phillips]

Try

=MAX(COUNTIF(range,IF(range<>"",range)))

[JimS]

Excellent - as always...

Thanks.

Now to figure out how to count the number of duplicates there are within a column when there are several "sets" of duplicates...

[Bob Phillips]

Count the uniques and take that away from the total count.