|
Count but in Diffrent way
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 |
Count but in Diffrent way
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 |
Count but in Diffrent way
In B1:
=countif(a:a,b1) and drag down as far as you need. Hardeep_kanwar wrote: 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 -- Dave Peterson |
Count but in Diffrent way
hi
with name in column A....try this..... =COUNTIF(A$2:A$13,A2) adjust the range as needed. regards FSt1 "Hardeep_kanwar" wrote: 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 |
Count but in Diffrent way
Thanks Work Perfectly
Hardeep kanwar "FSt1" wrote: hi with name in column A....try this..... =COUNTIF(A$2:A$13,A2) adjust the range as needed. regards FSt1 "Hardeep_kanwar" wrote: 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 |
Count but in Diffrent way
Hey Dave you mean
=countif(a:a,a2) Work perfectly Hardeep kanwar "Dave Peterson" wrote: In B1: =countif(a:a,b1) and drag down as far as you need. Hardeep_kanwar wrote: 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 -- Dave Peterson |
Count but in Diffrent way
Almost.
Actually, I meant: =countif(a:a,a1) (starting in B1) Thanks for catching my error. Hardeep_kanwar wrote: Hey Dave you mean =countif(a:a,a2) Work perfectly Hardeep kanwar "Dave Peterson" wrote: In B1: =countif(a:a,b1) and drag down as far as you need. Hardeep_kanwar wrote: 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 -- Dave Peterson -- Dave Peterson |
| All times are GMT +1. The time now is 07:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com