Want to count how many of each entry in a column

[joezeppy]

This seems so elementary that I'm embarrassed to ask but...

I have a list in a column and just want to count how many of each entry exists and place that number in another list:

Column A Column B Column C


abogado 4 abogado
abogado 7 mammamia
abogado 8 trifecta
abogado
mammamia
mammamia
mammamia
mammamia
mammamia
mammamia
mammamia
trifecta
trifecta
trifecta
trifecta
trifecta
trifecta
trifecta
trifecta

An image is here: 12.23.2013-13.59.36 - joezeppy's library

It's as simple as that. I want to create a table that lists the number of entries for each cell in column a and then lists the entry next to it. Can I use a pivot table or something?

Any help appreciated ...

 

[VBA Geek]

COUNTIF - Excel - Office.com

 

[wigi]

Can I use a pivot table or something?

Definitely! Use pivot table and in 30 seconds you're done.

 

[joezeppy]

Definitely! Use pivot table and in 30 seconds you're done.

Yeah, duh. Thanks. That worked.