Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort names and birth dates
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort names and birth dates
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 |
#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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort names and birth dates
I guess I don't understand what you're looking for.
Maybe a bigger explanation or some sample (plain text) data with the results you'd like to see would help. Or maybe someone who understands the question will jump in. orange wrote: 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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort names and birth dates
Hopefully this example works:
I have a spread sheet with two columns: Column A Column B John Anderson 09/03/08 Dave Anderson 08/09/08 John Anderson 07/03/08 Marsha Anderson 06/08/08 Dave Anderson 08/09/08 I am looking for a way to extract the duplicate names that have the same birth date i.e. Dave Anderson 08/09/08 Is this something that can be done? thanks for your help! "Dave Peterson" wrote: I guess I don't understand what you're looking for. Maybe a bigger explanation or some sample (plain text) data with the results you'd like to see would help. Or maybe someone who understands the question will jump in. orange wrote: 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort names and birth dates
I think the first suggestion and one of Chip's techniques will work.
Did you try it? Or if you want to extract to a different area, then using the concatenated cell and advanced filter with unique records should work. See Debra Dalgleish's site: http://contextures.com/xladvfilter01.html#FilterUR orange wrote: Hopefully this example works: I have a spread sheet with two columns: Column A Column B John Anderson 09/03/08 Dave Anderson 08/09/08 John Anderson 07/03/08 Marsha Anderson 06/08/08 Dave Anderson 08/09/08 I am looking for a way to extract the duplicate names that have the same birth date i.e. Dave Anderson 08/09/08 Is this something that can be done? thanks for your help! "Dave Peterson" wrote: I guess I don't understand what you're looking for. Maybe a bigger explanation or some sample (plain text) data with the results you'd like to see would help. Or maybe someone who understands the question will jump in. orange wrote: 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 -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort names and birth dates
Hi Dave,
Thank you soooooo much for your advice. I am now able to identify what I was looking for. Again, thank you! "Dave Peterson" wrote: I think the first suggestion and one of Chip's techniques will work. Did you try it? Or if you want to extract to a different area, then using the concatenated cell and advanced filter with unique records should work. See Debra Dalgleish's site: http://contextures.com/xladvfilter01.html#FilterUR orange wrote: Hopefully this example works: I have a spread sheet with two columns: Column A Column B John Anderson 09/03/08 Dave Anderson 08/09/08 John Anderson 07/03/08 Marsha Anderson 06/08/08 Dave Anderson 08/09/08 I am looking for a way to extract the duplicate names that have the same birth date i.e. Dave Anderson 08/09/08 Is this something that can be done? thanks for your help! "Dave Peterson" wrote: I guess I don't understand what you're looking for. Maybe a bigger explanation or some sample (plain text) data with the results you'd like to see would help. Or maybe someone who understands the question will jump in. orange wrote: 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 -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort names and birth dates
Glad you got it working.
orange wrote: Hi Dave, Thank you soooooo much for your advice. I am now able to identify what I was looking for. Again, thank you! "Dave Peterson" wrote: I think the first suggestion and one of Chip's techniques will work. Did you try it? Or if you want to extract to a different area, then using the concatenated cell and advanced filter with unique records should work. See Debra Dalgleish's site: http://contextures.com/xladvfilter01.html#FilterUR orange wrote: Hopefully this example works: I have a spread sheet with two columns: Column A Column B John Anderson 09/03/08 Dave Anderson 08/09/08 John Anderson 07/03/08 Marsha Anderson 06/08/08 Dave Anderson 08/09/08 I am looking for a way to extract the duplicate names that have the same birth date i.e. Dave Anderson 08/09/08 Is this something that can be done? thanks for your help! "Dave Peterson" wrote: I guess I don't understand what you're looking for. Maybe a bigger explanation or some sample (plain text) data with the results you'd like to see would help. Or maybe someone who understands the question will jump in. orange wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
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) |