Assuming the data is on sheet1, on another sheet list the dates and names
and add

=INDEX(Sheet1!C1:C100,MATCH((A2=Sheet1!A1:A100)*(B 2=Sheet1!B1:B100),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"sarahmarsden" wrote in message
ups.com...
Hello,

I have a list as follows, and I would like to get the lastest Number
Ordered for each Person based on the date.

Date Person Order
10/10/06 Person 1 15
10/10/06 Person 2 25
15/10/06 Person 1 10

ie I would like to see the following as a result

Date Person Order
10/10/06 Person 2 25
15/10/06 Person 1 10

Thanks in advance.