MODE function where there are no common functions.
 

I have a situation where I have a list of numbers where there are no
duplicates. Instead of N?A I would like a blank cell.

Is there any way to do this with an IF statement.

Something like =if (MODE(a1.a11)="NA","",(MODE(a1.a11)))? This seems to work
when mode produces a value, but not when there are no duplicates.

MODE function where there are no common functions.
 

Try it like this:

=IF(ISNA(MODE(A1:A11)),"",MODE(A1:A11))

--
Biff
Microsoft Excel MVP


"DJFudd" wrote in message
...
I have a situation where I have a list of numbers where there are no
duplicates. Instead of N?A I would like a blank cell.

Is there any way to do this with an IF statement.

Something like =if (MODE(a1.a11)="NA","",(MODE(a1.a11)))? This seems to
work
when mode produces a value, but not when there are no duplicates.