View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default 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)))