To whom it may concern:

I have a spreadsheet that is populated by an online survey where a survey taker can enter as many times as she desires and can change responses. However, I am only concerned with the most recent response.

For example:
Column A: Column C: Column D:
Timestamp User Name Entry
12/10/12 07:37:12 Jon Fish
12/10/12 07:47:12 Larry Fish
12/10/12 07:57:12 Jon Chips


My index-match function for Larry is simple, =index(D:D)Match("Larry",C:C,0) However, if I ask the same thing for Jon, I return nothing my return is not exact. I would like to not only find one result for Jon, but have it based on the most recent time-stamp. *** The time stamp will be in ascending order.

Please advise.