Using the mode function
"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)))
|