Extracting the earliest and latest date from duplicate entries

[Cartoon]

Excel Guru's,

I've been reading and watching videos for the past week and I'm struggling with the below scenario. I'm an IT guy not an analyst, but have been learning a lot.

I'm assisting a friend whom is looking for metrics for a scholarship program she oversees. Any assistance you are able to provide will be greatly appreciated. There are thousands of recipients so please keep this as dynamic as possible. I'm using excel 2007 on Win 7.

Raw Data Desired Result Name Date Graduated Name Earliest Date Latest Date Graduated Mike 1/1/2011 N Mike 1/1/2011 3/1/2012 Y Mike 4/1/2011 N Tom 10/4/2010 12/1/2012 N Mike 3/1/2012 Y Jen 5/17/2010 8/27/2011 Y Tom 10/4/2010 N Tom 12/1/2012 N Jen 8/10/2011 N Jen 5/17/2009 N Jen 9/10/2010 N Jen 8/27/2011 Y <tbody> </tbody>

<tbody>
</tbody>

 

[AD_Taylor]

Try something like this:

Excel 2010
	A	B	C	D	E	F	G	H
1	Raw Data				Desired Result
2	Name	Date	Graduated		Name	Earliest Date	Latest Date	Graduated
3	Mike	01/01/2011	N		Mike	01/01/2011	03/01/2012	Y
4	Mike	04/01/2011	N		Tom	10/04/2010	12/01/2012	N
5	Mike	03/01/2012	Y		Jen	17/05/2009	08/10/2011	Y
6	Tom	10/04/2010	N
7	Tom	12/01/2012	N
8	Jen	08/10/2011	N
9	Jen	17/05/2009	N
10	Jen	09/10/2010	N
11	Jen	27/08/2011	Y
Sheet1

Cell Formulas
Range	Formula
F3	{=MIN(IF($A$3:$A$11=$E3, $B$3:$B$11, ""))}
G3	{=MAX(IF($A$3:$A$11=$E3, $B$3:$B$11, ""))}
Press CTRL+SHIFT+ENTER to enter array formulas.

Had to change some of your dates to European format to properly test but should work for you.
Also it is dynamic as in when the data changes the formulas will update, but not sure how quick it will be for you. I've been told array formulas are normally slower than standard formulas.

 

[Cartoon]

Cheers! It worked. Thank you for your quick reply!

 

[AD_Taylor]

No problem, glad it worked for you and thanks for the feedback