HI
Try this: =COUNTIF(H1:H30,"john") change names and range if needed.
HTH
John
"Hardeep_kanwar" wrote in message
...
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