Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check for duplicate names in spreadsheet
Hi,
I have a rather large spreadsheet with thousands of names and personal details (numeric). Can somebody please show me how I can check for duplicate members names, and can I apply the same formula for duplicate personal details? I have a separate column for first name and surname. Thanking you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check for duplicate names in spreadsheet
I would insert a new column to join the two names into one field.
=a2&"|"&b2 (The | is just a separator) Then I'd use some of the techniques at Chip Pearson's to find duplicates for this column. http://www.cpearson.com/excel/duplicat.htm After finding the duplicates, I think knowing which formulas to apply would either boil down to consistency or some sort of manual effort. (I don't have a guess.) lunagirl wrote: Hi, I have a rather large spreadsheet with thousands of names and personal details (numeric). Can somebody please show me how I can check for duplicate members names, and can I apply the same formula for duplicate personal details? I have a separate column for first name and surname. Thanking you in advance. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check for duplicate names in spreadsheet
Thanks so much for your help Dave, it was exactly what I was looking for.
Very grateful Lunagirl "Dave Peterson" wrote: I would insert a new column to join the two names into one field. =a2&"|"&b2 (The | is just a separator) Then I'd use some of the techniques at Chip Pearson's to find duplicates for this column. http://www.cpearson.com/excel/duplicat.htm After finding the duplicates, I think knowing which formulas to apply would either boil down to consistency or some sort of manual effort. (I don't have a guess.) lunagirl wrote: Hi, I have a rather large spreadsheet with thousands of names and personal details (numeric). Can somebody please show me how I can check for duplicate members names, and can I apply the same formula for duplicate personal details? I have a separate column for first name and surname. Thanking you in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet shortcuts not working | Setting up and Configuration of Excel | |||
Can I print the tab names in an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Setting Tab Names To Dates In Spreadsheet | Excel Worksheet Functions | |||
Can you sort with check boxes? | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) |