Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Verifying value of a cell | Excel Discussion (Misc queries) | |||
Verifying your credentials for opening content with restricted pe. | Excel Discussion (Misc queries) | |||
Verifying Email addresses etc using macros | Excel Discussion (Misc queries) | |||
Data and Other Records | Charts and Charting in Excel | |||
Verifying Dates | Excel Worksheet Functions |