Count but in Diffrent way

H

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
 
F

FSt1

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

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

adjust the range as needed.

regards
FSt1
 
H

Hardeep_kanwar

Thanks Work Perfectly

Hardeep kanwar

FSt1 said:
hi
with name in column A....try this.....

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

adjust the range as needed.

regards
FSt1
 
D

Dave Peterson

Almost.

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

Thanks for catching my error.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top