Formula that shows the name and birthday of the youngest person in a table

**Thomas11** · 04-24-2013, 02:17 AM

I have a project due for my class and I am stumped on a question. In A5:A25 are the names of people, B5:B25 are the gender and C5:C25 are their birthdates. I am looking for a formula that shows the name and birthday of the youngest person listed. I am just stumped! Any help would be greatly appreciated!!

**Fotis1991** · 04-24-2013, 02:36 AM

try using INDEX &MATCH with min-small function...

**Thomas11** · 04-24-2013, 12:49 PM

We didn't learn the index or match functions in school. Or the small. So I am lost lol. Any replies would be awesome

**Lemice** · 04-24-2013, 01:19 PM

Hello,

Assuming you have data from row 5 to 25 and column A to C like you described, then paste this formula in D5

Please Login or Register  to view this content.

This will return the birthday of the youngest person.
Paste this formula in E5

Please Login or Register  to view this content.

This will return the name of that youngest person.
Similarly, paste this on F5

Please Login or Register  to view this content.

This will return the gender of that youngest person.

In case they do not give you the expected results, please provide a small sample file, that will be easier for others to help you also.

**Thomas11** · 04-24-2013, 07:16 PM

Thank you Lemice!

**vijayendra19** · 11-11-2014, 09:47 AM

Thanks Lemice. Which formula do i use to get the date of birth of the 2nd youngest person in a table which has the names and date of birth. Example given below
DOB Name
3/31/1998 Adella
7/28/2006 Allen
10/11/2007 Anne
11/11/1994 Beverly
6/15/2005 Bonnie
3/11/2005 Brian
6/5/2008 Carol
1/9/2008 Christopher