MODE function where there are no common functions.

  • Thread starter Thread starter DJFudd
  • Start date Start date
D

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.
 
Back
Top