| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort names and birth dates
Hi Dave,
I am actually needing to identify the duplicate names with their duplicate birthdates. Any suggestions? thanks "Dave Peterson" wrote: Both the name and birthdate have to be duplicated??? If yes... I would insert a new column and concatenate the name and birthdate. =a1&"...."&text(b1,"yyyy-mm-dd") Then use the techniques at Chip Pearson's site: http://www.cpearson.com/excel/Duplicates.aspx orange wrote: I have a spread sheets with a couple of thousand names and birth dates. I am wanting to locate the duplicate name and birth date and put these in another column. Any suggestions? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to sort a column containing date of birth? | Excel Discussion (Misc queries) | |||
| Birth Dates | Excel Discussion (Misc queries) | |||
| Transfer names and date of birth | Excel Discussion (Misc queries) | |||
| Cemetery birth and death date sort | Excel Discussion (Misc queries) | |||
| How do I work out people's exact ages from their Dates of Birth? | Excel Discussion (Misc queries) | |||
Threaded Mode
