Count but in Diffrent way

[Hardeep_kanwar]

Hi ! Experts

My data look like this:
Name
Hardeep
Hardeep
pai
pai
renu
aditya
john
john
john
john
gorden
gorden

And i want to get the count of each name in next Column like mentioned below
Example

Name Count
Hardeep 2
Hardeep 2
pai 2
pai 2
renu 1
aditya 1
john 4
john 4
john 4
john 4
gorden 2
gorden 2

 

[John]

HI
Try this: =COUNTIF(H1:H30,"john") change names and range if needed.
HTH
John

 

[Dave Peterson]

In B1:
=countif(a:a,b1)
and drag down as far as you need.

 

[FSt1]

hi
with name in column A....try this.....

=COUNTIF(A$2:A$13,A2)

adjust the range as needed.

regards
FSt1

 

[Hardeep_kanwar]

Thanks Work Perfectly

Hardeep kanwar

hi
with name in column A....try this.....

=COUNTIF(A$2:A$13,A2)

adjust the range as needed.

regards
FSt1

 

[Hardeep_kanwar]

Hey Dave you mean
=countif(a:a,a2)

Work perfectly

Hardeep kanwar

 

[Dave Peterson]

Almost.

Actually, I meant:
=countif(a:a,a1)
(starting in B1)

Thanks for catching my error.