How can excel list how many times an entry is in the database?

I have a list of names and I want excel to give me a new list with each name and how many times it is in the database. Is this possible?

For example:

John
Pete
John
Brad
John
Pete

would have to become:

John 3
Pete 2
Brad 1

thx for the help

Hi,

In my opinion, the best solution is the one proposed by Debra ...

http://www.contextures.com/xlPivot07.html#Unique

HTH
Carim

I don't see how that works in this situation. I must say I'm not 2 good with excel, but isn't this a totally different database with a totally different problem?

Hi,

See attached sample ...

HTH
Carim

thx, I think I found out how it works. Not that I understand what I'm doing, but at least I get the result I want.

Learning XL or pivot tables comes like anything else ... with some practice ...

Thanks for the feedback

Carim