find most commonly occuring string values with a single formula

Hi all, just joined the forum,

I have a formula that calculates the most common value from a long column of string values.

=INDEX('The List'!C$2:C$4999,MATCH(MAX(COUNTIF('The List'!C$2:C$4999,'The List'!C$2:C$4999)),COUNTIF('The List'!C$2:C$4999,'The List'!C$2:C$4999),0))

In the adjacent cell I have a simple COUNTIF formula that adds up the number of these like this:

=COUNTIF('The List'!C:C,B16)

- so far, so good, the result is:

(most common value) | 670

But, what I'd like to be able to report is a top five, e.g


(most common value) | 670
(second most common value) | 554
(third most common value) | 501

etc.


Ideally I'd like to do this with a single formula for each calculation rather than have a bunch of cells used to do the calculations, as this needs to be adaptable by other users who will have even less understanding of Excel than I do!

Thanks

Use LARGE function instead of MAX