duplicate last name and date of birth

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need help with a formula, please, I have a MS Excel spreadsheet with

A1=LAST NAME
B2=DATE OF BIRTH

and I need a formula to show me all instances where the last name AND the
date of birth repeat. I found EXACT formulas, AND formulas, OR formulas, and
even used Conditional Formating with a COUNTIF formula. But non of them are
able to perform a cross comparision or at least I don't know how to enter it
properly.
 
Hi,
This is not a formula solution. Sort the records and then
Data/Filter/Advanced filter/Unique Records Only. Not exactly sure what you
are trying to accomplish in the end, but maybe this will help.
 
Assuming you have a typo in your message and the DOB is in fact in B1 (not
B2), one way is to use a helper column containing this formula which gets the
name and DOB together into one cell:

=A1&" "&TEXT(B1,"yyyymmdd")

If the layout is correct as you show it (instead of the data for one person in
two columns in the same row), you are making your life much more difficult. If
that's the case, you've got to create a list that has the name and DOB for
each person, without blanks.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine two spreadsheets into one 3
calculating age from date of birth 2
Calculating age from date of birth and ignoring if blank 5
Excel to notify date of birth 3
Constant date in one cell 1
ELAPSED TIME BETWEEN TWO DATES 5
Sort names and birth dates 7
calculate date of birth with an end date and age 1

Back
Top