"Harlan Grove" wrote in message
ups.com...
"T. Valko" wrote...
MODE returns the *first* mode of the range. For example:
...
. . . You can add a test that returns a blank (or whatever you
want) if there is no mode:

=IF(ISNA(MODE(A1:A10)),"",
MAX(IF(COUNTIF(A1:A10,A1:A10)=MAX(COUNTIF(A1:A10 ,A1:A10)),A1:A10)))

Do less work, get the same result.

=IF(ISNA(MODE(x)),"",MAX(IF(COUNTIF(x,x)=COUNTIF(x ,MODE(x)),x)))


Yep, that "works" for me!

--
Biff
Microsoft Excel MVP