Hi Folks

Would be grateful of any advice.

I'm trying to generate a 'Top 5' of the most frequently occurring text strings in a column.

In Column A is a list of countries:

A
1 Germany
2 United Kingdom
3 Germany
4 Italy
5 United Kingdom
6 United States of America
7 Ireland
...

In another column, without the use of pivot tables or filters, I'd like to have a Top 5 list which will list, in the correct order, the most frequently occurring text strings, like this:

C
D
1 Top 5 Count
2 Germany 27
3 United Kingdom 23
4 Italy 22
5 United States of America 16
6 France 11

Can anyone suggest a formula which would do the job? Nothing I've found via Google seems to do the job.

Much obliged,

Paul