Counting names in a list.

[Dxmiian]

Hi,

I have a list of names from column B2 down.. sometimes an individual name appears more than once.
I would like a table that shows the name and how many times the name appears in the list.
I have no idea sorry :/

Thanks for any help,

Damian

[Pepe Le Mokko]

=COUNTIF($B$2:$B$100,$B2) and pull down
Adapt range as needed
Or a Pivot Table ( which might be overkill but is clearer and easier)

[Dxmiian]

perfect pal, thanks.