How can I lookup and count mulitple names?
Closed
Tonya
-
Apr 25, 2012 at 11:47 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - May 1, 2012 at 08:42 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - May 1, 2012 at 08:42 AM
Related:
- How can I lookup and count mulitple names?
- Count names in excel - Guide
- Https //accounts.google.com/sign in/v1/lookup - Guide
- My contacts list names - Guide
- Excel count occurrences - Guide
- Monk names wow - Guide
3 responses
Mehedad
Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
3
Apr 26, 2012 at 06:08 AM
Apr 26, 2012 at 06:08 AM
You can select the entire Column and use Conditional Formatting (Home Tab) -> Highlight Cells Rules -> Duplicate Values...
This will highlight the duplicate values
Before that, you can sort the data alphabetically to see the number of occurance for each name.
This will highlight the duplicate values
Before that, you can sort the data alphabetically to see the number of occurance for each name.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
May 1, 2012 at 08:42 AM
May 1, 2012 at 08:42 AM
Hi Tonya,
If you're still working with excel 2003 and want a formula solution, then you could do the following:
Since column C is blank:
cell C2: =IF(A2=A1,1,"")
Drag this formula down.
Now apply autofilter.
First alphabetize column A using the filter.
Goto column C's header and choose to show 1.
Now remove all the rows that are still visible.
Finally remove all filters and the formula's from column C.
Best regards,
Trowa
If you're still working with excel 2003 and want a formula solution, then you could do the following:
Since column C is blank:
cell C2: =IF(A2=A1,1,"")
Drag this formula down.
Now apply autofilter.
First alphabetize column A using the filter.
Goto column C's header and choose to show 1.
Now remove all the rows that are still visible.
Finally remove all filters and the formula's from column C.
Best regards,
Trowa
