Try this !

Col A - Id
Col B - Action
Colc C - Date
Col D - Latest action
Col E - Latest date

So D2 put this formula =LOOKUP(E2,$C$2:$C$6,$B$2:$B$6)

in E2 put this formula =MAX(IF(--($A$2:$A$6=A2),$C$2:$C$6,""))


On Sep 12, 8:18*am, wrote:
if i have the following table...i want to return the latest results.
is it possible?

e.g.
ID * * * *Action * * Date
a1 * * * jump * * * *2/9/2008
a2 * * *walk * * * * * 3/9/2008
j10 * * jump * * * * *3/9/2008
a1 * * move * * * * *3/9/2008
a2 * * climb * * * * *5/9/2008

I want to have follow results...

ID * * Action * *Date * * * * * * * * *Latest_action * Latest_Date
a1 * * * jump * * * *2/9/2008 * * *move * * * * * * * * * *3/9/2008
a2 * * *walk * * * * * 3/9/2008 * * *climb * * * * * * * * * *5/9/2008
j10 * * jump * * * * *3/9/2008 * * *jump * * * * * * * * * * 3/9/2008
a1 * * move * * * * *3/9/2008 * * *move * * * * * * * * * *3/9/2008
a2 * * climb * * * * *5/9/2008 * * * *climb
5/9/2008