JimS
11-01-2012, 12:59 PM
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
{=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