Finding Duplicate customers

[nander]

In column A there is a listing of customer numbers. I have duplicates in
this file. I need to identify the duplicates quickly. I've tried the
help section in the forum to highlight or name the duplicates but have
not had much success.


+-------------------------------------------------------------------+
|Filename: cust duplicates.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4647 |
+-------------------------------------------------------------------+

 

[Dark_Templar]

I had the similar issue,see:

http://www.excelforum.com/showthread.php?t=533446

Will work fine for you too I think

 

[Chip Pearson]

See http://www.cpearson.com/excel/duplicat.htm .

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"nander" <[email protected]>
wrote in message
news:[email protected]...

 

[Toppers]

In Column G:

=IF(COUNTIF($A$1:$A$2133,"=" &A2)>1,"Duplicate","") and copy down

Nearly ALL customers are duplicated on the file you posted