| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding duplicate data in a worksheet | Excel Discussion (Misc queries) | |||
| finding & filtering out duplicate cells | Excel Discussion (Misc queries) | |||
| Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) | |||
| Finding duplicate records in Excel | Excel Discussion (Misc queries) | |||
| Finding duplicate data | Excel Worksheet Functions | |||
Hybrid Mode
