MODE function where there are no common functions.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding only NONBLANK cells 2
What is the priority of Mode function? 3
How to sort AlphaNumeric Data sequentially with spaces 4
Mode Function or MODE Function -- Can't get it to work!! 4
Mkae Mode function return "" instead of #N/A when there is no Mode 1
Is this really not possible?? 18
Stepping down a cell when a value is entered 2
Excel Named Ranges and Conditional Format 3

Top