Top 5 Text Strings from List - Formula advice

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

Hi,

Please see the attached file. I have added a helper column to identify the duplicates and their count.

Thanks so much, cbatrody - absolutely perfect!

Much appreciated

Paul

You are welcome

You can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.