Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you use filter to view duplicated records in Excel?
I have a large list of customer name and phone numbers that is continuously
being added in bulk from other worksheets. I need to be able to check that the records are not being duplicated. I would appreciate any help you could give me.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you use filter to view duplicated records in Excel?
If you want to find "UNIQUE" Records - you can select the Column - then DATA - FILTER - ADVANCED FILTER - Then Check the "UNIQUE" records and then copy that list and paste into a new WORKSHEET. If you want to find "Duplicates" the easiest way I have found is to sort your records on the column you want to check. Then have the cell above the records you want to check for duplicates as a "blank" or a column Title. For this example I would start the records you want to check at Cell A2 (you always want a Not Dup for your first value): Then enter the following formula in whatever column you want and copy it down the list: =IF(A2=A1,"Dup","Not Dup"). You Can enter whatever values you want for "DUP" and "Not Dup" -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=499275 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you use filter to view duplicated records in Excel?
If this was something I had to do frequently, I would use Jim Cone's fine
commercial Add-in called XL Companion. Available at: http://www.realezsites.com/bus/primitivesoftware/ Vaya con Dios, Chuck, CABGx3 "Sharon" wrote: I have a large list of customer name and phone numbers that is continuously being added in bulk from other worksheets. I need to be able to check that the records are not being duplicated. I would appreciate any help you could give me.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I show number of records that meet criteria filter | Excel Discussion (Misc queries) | |||
Deleting specific records | Excel Discussion (Misc queries) | |||
How do I view all file types permanantly when opening in Excel? | Setting up and Configuration of Excel | |||
Excel 2003 Filter Problem | Excel Discussion (Misc queries) | |||
Duplicate records in Excel | Excel Discussion (Misc queries) |