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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks