Hi Heliocracy,

I would have some ideas about your problem, but your dates are not presented
under the same format as the one I use.

Why don't you resubmit your data using straight numbers instead?

(Okay! I understand that there are loads of people from the States here that
will have the same date format as you and many are also talented enough to
help you... You will probably not need to do it this time before you get an
answer... But I just wanted to let you know what I bumped into fiddling
around with your data: maybe next time you can change it right from the start
and POSSIBLY get an answer earlier...)

Cheers,
Félix

"Heliocracy" wrote:

Please help, I need to execute a complex MAX and LOOKUP.

I have a worksheet set up like this:

col D col E col F col G
Mike 1 10/1/2007 10/23/2007
Mike 3 10/24/2007 2/1/2008
Mike 7 2/2/2008 2/21/2008
Mike 2 2/22/2008 3/17/2008
Phil 11 10/1/2007 10/19/2007
Phil 44 10/20/2007 3/13/2008
George 56 2/1/2008 3/14/2008
George 13 3/15/2008 3/19/2008

On a second worksheet, I start by putting all the names (one time each) in
column A. For each of these names in column A, I need to return the largest
number that appears in column E of the above table, where column D matches
the name in col A of the new worksheet. Then, in cols C and D of the new
worksheet, I need the dates from cols F and G above which appear on the same
row as the maximum number which has been returned to the col B of the new
worksheet.

The new worksheet would look like this:

col A col B col C col D
Mike 7 2/2/2008 2/21/2008
Phil 44 10/20/2007 3/13/2008
George 56 2/1/2008 3/14/2008

I'm at a loss so far...How do I go about making this happen?