Need Formula for Last Occurance

[Reignman]

I need a formula or array that will look up the last time a specifi
thing occured.

A1:A1000 has the date it occured
B1:B1000 has the thing that occured

A1001 is where I want the formula or array to display the answer
B1001 will be the occurance I enter to be looked up

Thanks, Joh

 

[Biff]

Hi!

Array entered:

=MAX(IF(B1:B1000=B1001,A1:A1000))

Format as DATE

Biff

 

[Aladin Akyurek]

Care to provide a tiny sample along with the expected result?