How do I create a list of the most frequent numbers appearing in an exisiting random list?

I have several lists of numbers. I am trying to get a simple report of the the 5 most frequent numbers, in decending order of frequency.

Hello. Do a search of the MODE function and see if that helps you.

You could try using the FREQUENCY function, then sorting the result. Of course, multi-cell arrays don't sort, so you'll have to do a paste values first.

I know of no formula that does this directly. If you need such a formula, you could post this question in the VBA section