MODE function where there are no common functions.

[DJFudd]

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.

 

[T. Valko]

Try it like this:

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