A
Amiranda
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!
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!