return a number from a cell based on the lastest date
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.
|