I have a large data sheet in Excel with columns C, D, E, and F containing time (2024/1/1), location (New York), surname (Smith), and first name (John) data, respectively.

On a separate sheet I would like to generate a top 3 (descending) of the values in these columns (i.e., showing the 3 most common values that appear in each of the above columns).

I am using the below formula, which successfully generates the most column value:

=index(data!C2:C999,match(max(countif(sheet1!C2:C999,sheet1!C2:C999)),countif(sheet1!C2:C999,sheet1!C2:C999),0))

Could anyone help me to generate a top 3 instead?

Many thanks in advance