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!

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!

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!