MODE isn't working properly.

M

M Keeler

I am trying to find the mode of my array, but I want it to return nothing if
there is no number which occurs most often. Instead, they give me the first
number which appeared.


For example:

MODE(4, 3, 4, 3) will return 4, and
MODE(3, 4, 4, 3) will return 3.


Is there some way I can fix or bypass this?
 
B

Biff

Hi!

Try this:

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=IF(LARGE(FREQUENCY(A1:A4,A1:A4),1)=LARGE(FREQUENCY(A1:A4,A1:A4),2),"",MODE(A1:A4))

Biff
 
Top