Finding last occurance as Non-array formula?

Worksheet is setup like so:
A
01/01/07 One
01/05/07 Four
01/21/07 One
03/10/07 Four
04/10/07 Three
05/21/07 Two
08/10/07 One
08/12/07 Two

I'm currently using an array forumla in a list on the sheet to list off each name and the last date it occured at, however with the number of names i have to search for it's slowing down the processing and saving time since i have a list of about 20 things and each one has it's own array formula.
{=MAX(IF(B1:B500="One",A1:A500))}

Is there a better or alternate formula i could use (non-array formula) which would accomplish the same goal (find the last occurance of an entry and the corresponding date located in a column to the left of it)?

Hi Ratboy

Assuming those values in A1:B8 then you could use the following formula (it may not be a huge improvement on what you have though):

Please Login or Register  to view this content.

Hope this helps!

Richard

EDIT: this also assumes that the dates are sorted ascending down column A...