Hi all,

Column D contains staff members names. I would like to be able to count the
number of times each member was listed. For example, if column D is as
follows:

D
Smith
David
Smith
Roberts
Baker
Smith

I would like to get the following result:
Employee 'Smith' listed '3' times
Employee 'David' listed '1' time, etc.

Because i don't have a pre-identified list of employees, i can't use the
formula:
=COUNTIF(D:D,"=Smith")

Is there a formula that can:
- Display the Unique Values and
- the number of times each one of them appeared

I use Excel 2003

Many thanks in advance
Tendresse