Finding Duplicate customers
 

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 |
+-------------------------------------------------------------------+

--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=533457

Finding Duplicate customers
 

I had the similar issue,see:

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

Will work fine for you too I think.


--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=533457

Finding Duplicate customers
 

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

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


"nander"
wrote in message
...

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
|
+-------------------------------------------------------------------+

--
nander
------------------------------------------------------------------------
nander's Profile:
http://www.excelforum.com/member.php...fo&userid=6156
View this thread:
http://www.excelforum.com/showthread...hreadid=533457

Finding Duplicate customers
 

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

"nander" wrote:


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 |
+-------------------------------------------------------------------+

--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=533457