counting the occurance

  • Thread starter Thread starter sri
  • Start date Start date
S

sri

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.
If I need to write any macro how do I.

Thank you,
sri k.
 
Two options...
1) Build a pivot table from your name data.
2) Create a list of distinct names and use a CountIf formula like...

=COUNTIF(Range,Cell)

where Range houses the names and Cell is the top cell of the list of distict
names.
 
Sri,

Try

=COUNTIF($A$1:$A$100,B1)

--

HTH

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

sri k.
-----Original Message-----
Sri,

Try

=COUNTIF($A$1:$A$100,B1)

--

HTH

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




.
Click to expand...
 
Back
Top