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

[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

 

[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

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

 

[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

 

[Aladin Akyurek]

See your earlier post for an additional reply...