Group and Count Text from a Column

[maxmangion]

I have an excel sheet and one of the columns store the name of a country. I would like to see how many times each country features in this list e.g. Spain 5, Italy 5, Germany 4 etc

I can do this easily in Access using a total query by grouping and use a count, but I am stuck how I should go about it in excel.

Any pointers in the right direction would be greatly appreciated.

Thank you.

 

[Minty]

Select all the data in the spreadsheet and click on insert , then select pivot - should all be clear as mud

 

[maxmangion]

Thanks, I will check that out.