How to include "Aggregate" to index match

[Patcheen]

HI all

Im currently using this formula

=INDEX(EMD!A2:A2000,MATCH(1,(U1=EMD!B2:B2000)*(V1=EMD!C2:C2000),0))

a2:a2000 are dates

B2:B2000 is numbers 100 to 1000 and c2:c2000 are also numbers 100 to 1000

im trying to include Aggregate so i can see when 2 numbers appeared together more recently.

the above formula works perfectly but only gives me the first time they appeared together

TIA

 

[AhoyNC]

You will need to change the reference cells, but hopefully the AGGREGATE example above (post# 8)will help or the answer given by Fluff.

 

[Patcheen]

sorted... Thank you to both of you for your help ye have been brill thank you both so much

 

[Fluff]

Glad we could help & thanks for the feedback.