Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find duplicates in address register
I have a list of about 600 address entries.
Example: Last name : First name : Organization : Title : e-mail : Street : Post code : City Smith : John : SAAB : Manager : mail : Street 1: 1000 : London Johnson : Anna : Volvo : Manager : mail : Street 2 : 1200 : Brussels Smith : John : SWIFT : Manager : mail : Street 1: 1000 : London Smith : John : SAAB : Manager : mail : Street 1: 1000 : London I need a macro to identify the duplicate entries, sorting alphabetically didn't enough since I don't have the time to go through it manually and delete duplicate rows. I need to compare first the Last name, then the First name, then the Organization and then possibly also the title. After this I need the unique records in one list: Either by copying the unique records to a new sheet OR to just delete the duplicates OR to add a column with an added value - 1 for unique records and for the first instance of an entry and 2 for all duplicates. Not sure which one would be best/easiest. Can anyone help? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find duplicates in address register
try the Advance Filter, choose Unique records only and copy to another location
-- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Amiranda" wrote: I have a list of about 600 address entries. Example: Last name : First name : Organization : Title : e-mail : Street : Post code : City Smith : John : SAAB : Manager : mail : Street 1: 1000 : London Johnson : Anna : Volvo : Manager : mail : Street 2 : 1200 : Brussels Smith : John : SWIFT : Manager : mail : Street 1: 1000 : London Smith : John : SAAB : Manager : mail : Street 1: 1000 : London I need a macro to identify the duplicate entries, sorting alphabetically didn't enough since I don't have the time to go through it manually and delete duplicate rows. I need to compare first the Last name, then the First name, then the Organization and then possibly also the title. After this I need the unique records in one list: Either by copying the unique records to a new sheet OR to just delete the duplicates OR to add a column with an added value - 1 for unique records and for the first instance of an entry and 2 for all duplicates. Not sure which one would be best/easiest. Can anyone help? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find duplicates in address register
And I was looking for a complicated macro solution :-) Glad it was this easy
to solve my problem. Thanks! "Francis" skrev: try the Advance Filter, choose Unique records only and copy to another location -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Amiranda" wrote: I have a list of about 600 address entries. Example: Last name : First name : Organization : Title : e-mail : Street : Post code : City Smith : John : SAAB : Manager : mail : Street 1: 1000 : London Johnson : Anna : Volvo : Manager : mail : Street 2 : 1200 : Brussels Smith : John : SWIFT : Manager : mail : Street 1: 1000 : London Smith : John : SAAB : Manager : mail : Street 1: 1000 : London I need a macro to identify the duplicate entries, sorting alphabetically didn't enough since I don't have the time to go through it manually and delete duplicate rows. I need to compare first the Last name, then the First name, then the Organization and then possibly also the title. After this I need the unique records in one list: Either by copying the unique records to a new sheet OR to just delete the duplicates OR to add a column with an added value - 1 for unique records and for the first instance of an entry and 2 for all duplicates. Not sure which one would be best/easiest. Can anyone help? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find duplicates | Excel Worksheet Functions | |||
Find duplicates | Excel Discussion (Misc queries) | |||
Find Duplicates | Excel Discussion (Misc queries) | |||
Find and mark duplicates | Excel Discussion (Misc queries) | |||
Find duplicates | Excel Discussion (Misc queries) |