Finding recent date from list

[jimmy604]

This is my first post so I apologize if my request is easier than I expected. I have been trying to figure this out for a while. I have two columns of data. In column one is simply dates, in column two is the person attending on that date. There are various people who attend on various dates. What I am trying to find is the last time each person attended. Ive used index, max, and all kinds of formulas with no luck.

column 1 Column 2
08-Apr-15 Dan
09-Apr-15 Bill
10-Apr-15 Dan
11-Apr-15 Phil
12-Apr-15 Tom
13-Apr-15 Dan
14-Apr-15 Dustin
15-Apr-15 Dan
16-Apr-15 Phil
17-Apr-15 Bill
18-Apr-15 Dan

With this, when was the last time Dan attended, Bill, Phil and so on. If you can help, I would appreciate it so much.

 

[jimmy604]

The sheet name is totals, and I entered the peoples names in column k6 and their respective dates in L6 down

 

[jimmy604]

Got it. What I did was change the formula as follows and it worked

=LOOKUP(9.99999999999999E+307,1/(Sheet2!$B$2:$B$12="Dan"),Sheet2!$A$2:$A$12)

Thank you so much helping solve this problem for me.

 

[Aladin Akyurek]

Got it. What I did was change the formula as follows and it worked

=LOOKUP(9.99999999999999E+307,1/(Sheet2!$B$2:$B$12="Dan"),Sheet2!$A$2:$A$12)

Thank you so much helping solve this problem for me.

You are welcome. You can substitute for "Dan" a cell address which houses that name.