| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you do labels with diffrent recipients? | Excel Discussion (Misc queries) | |||
| TOO MANY DIFFRENT CELL FORMATS | Excel Discussion (Misc queries) | |||
| TOO MANY DIFFRENT CELL FORMAT | Excel Discussion (Misc queries) | |||
| I want to seperate two words in same cell to be in two diffrent ce | Excel Discussion (Misc queries) | |||
| how can i format a cell with 3 diffrent group to add | Charts and Charting in Excel | |||
![Hardeep_kanwar[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
