MODE isn't working properly.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

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

How do I find the highest of the most repeating values in a list ofnumbers ie. the max of the modes 1
Rank Formula 1
SUMPRODUCT or COUNTIF FOR TEXT VERIFIED LIST 1
How get Excel 2007 to return highest column 6
Mode-1 6
Lookup missing number(s) in column w/blanks & duplicates 3
COUNTIF 2
Sumproduct help with a difference 3

Back
Top