Please help me find a formula to show the 2nd most frequent

T

Tom

Please help me find a formula to show the 2nd, 3rd, 4th,
etc. most frequent numbers in a range of cells. I used
the mode function to find the most frequent but do not
know how to find the successive most frequent numbers.
Thanks.
Tom
 
R

Ron Rosenfeld

Please help me find a formula to show the 2nd, 3rd, 4th,
etc. most frequent numbers in a range of cells. I used
the mode function to find the most frequent but do not
know how to find the successive most frequent numbers.
Thanks.
Tom
Click to expand...

What were the issues with the answers already posted in your previous thread?

Or was that someone else who posted nearly the identical question?

Look for messages with subject: "How do I get the 2nd Mode in a range of cells"


--ron
 
B

Biff

Hi Tom!

Not easily done in a single formula. Another alternative
from the suggestions already made in the other post.

Use an advanced filter and copy the unique values to
another location. In the adjacent cells use a countif
formula then select both columns and do a descending sort
on the countif column.

Biff
 

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

Help!! find two number recurring numbers in row?? 1
How to find most popular choice from a text list? 6
How do I find the highest of the most repeating values in a list ofnumbers ie. the max of the modes 2
Most frequent string in a column matched against a value in its ro 1
Any formula to return the most frequent bin range? 15
Cumulative formula for word table 0
Second most frequent number in a data set in Excel? 5
How do I get the 2nd Mode in a range of cells 9

Top