Verifying uniqueness of records in data

[Guest]

Hello good people.

I’m having data tables with a list of records representing mailing list of
my customer.
How can I verify that every record is unique (for example: to avoid sending
two letters to the same customer)

Thanks in advance
Arad

 

[Guest]

How is the data organised and what field(s) can be tested for as unique?

 

[Guest]

Without seeing how your data are arranged it's difficult to be precise but
there are several ways here.

http://www.cpearson.com/excel/duplicat.htm

Mike

 

[Dave Peterson]

And remember that when you look for duplicates in excel, it means
duplicates--exact matches.

That may not be enough.

Mr. Arad Smith
Mister Arad Smith
Arad Smith
Dr. Arad Smith

aren't duplicates in excel's eyes, but would cause multiple letters to the same
recipient.

 

[Guest]

The fields are: first name, name, st. number, street, city, pincode,
telephone, e-mail, etc.
a "unique field" can be the e-mail, or the telephone number.
Or few fields together connected by "and" like first name "and" name, which
doesn't give 100% sure of a double record, but worth checking it manualy.