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