How can I lookup and count mulitple names?

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,

Can someone please help me? I have a excel file that has over 50K records and I need to identify all duplicate names row from row....is there a formula that I can use to quickly loate these?

Col A Col B Col C Col D
DENISE BAEHSER 5/14/1967
DENISE BAEHSER 5/14/1967
DENISE BAEHSER 5/14/1967
DENISE BAEHSER 5/14/1967
DENISE BAEHSER 5/14/1967
DENISE BAEHSER 5/14/1967

Thank you in advance.

3 replies

...(Sorry the columns attached lost it's format....(Cloumn C is currently blank).
Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
3
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.
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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