counting occurance of a name in a cell
 

Hi,
I have a column that will have names, which can be
repeated any no of times. for example in column A data is
as below.

alex
alex
edward
david
jim
david
edward
jim
david

I want to know how many times jim was repeated.
The result i am looking for is like below
col B col C
alex 2
david 3
edward 2
jim 2

Can anybody tell me how to do this using functions.
If I need to write any macro how do I.

Thank you,
sri k.
..

counting occurance of a name in a cell
 

Answered in worksheet.functions

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
...
Hi,
I have a column that will have names, which can be
repeated any no of times. for example in column A data is
as below.

alex
alex
edward
david
jim
david
edward
jim
david

I want to know how many times jim was repeated.
The result i am looking for is like below
col B col C
alex 2
david 3
edward 2
jim 2

Can anybody tell me how to do this using functions.
If I need to write any macro how do I.

Thank you,
sri k.
.