Right and thank you, but is there anyway to make the formula stop once the
frequency lowers from the mode, so I don't have to do that?

I didn't/don't mean to come off as sarcastic, either; a formula that returns
a frequency-ranked set of data is pretty neat in my naive little book.

"Pete_UK" wrote:

You could add this formula to D2:

=COUNTIF(A$2:A$10,C2)

and copy it down to give you a count of each of the numbers in C.
Doesn't answer your question, but useful nonetheless.

Pete