Verifying uniqueness of records in data
 

Hello good people.

Im 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

Verifying uniqueness of records in data
 

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

"arad" wrote:

Hello good people.

Im 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

Verifying uniqueness of records in data
 

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

"arad" wrote:

Hello good people.

Im 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

Verifying uniqueness of records in data
 

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.





arad wrote:

Hello good people.

Im 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

--

Dave Peterson

Verifying uniqueness of records in data
 

The fields a 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.

"Toppers" wrote:

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

"arad" wrote:

Hello good people.

Im 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