counting occurance of a name in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
..
 
Answered in worksheet.functions

--

HTH

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