LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default duplicate last name and date of birth

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Birth date from age JP6262AMY Excel Worksheet Functions 2 March 10th 08 06:30 PM
How do I convert a date of birth to an age? Michael Excel Worksheet Functions 1 February 5th 07 12:11 AM
formula to calculate age using birth date and current date lalah Excel Worksheet Functions 2 November 20th 05 10:51 PM
ages/date of birth irishchick28 Excel Worksheet Functions 1 March 21st 05 09:22 PM


All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"