Hi All,

Thank you very much for taking the time to provide various formulas.

I've received assistance with a similar scenario that was based on Counting
and Summing the relevant occurances of two specific numbers.

This time, I need to find /match two specific numbers that appear together
and return the Date of their LAST occurrence together.

I have a table of numbers that spans nine Columns (A-I)and 400+ Rows (20-
480). I have made the table a Dynamic Range called "Numbers". Each Row
contains numbers in ascending order. The Date is contained in a single
Column (J) - Dynamic Range called "Date".

Is there a formula that can check for two specific numbers Row by Row
through the (nine column) Range "Numbers" and Return the Date of their LAST
appearance together, from the Dynamic Range "Date"?

Column J = Dynamic Range "Date"
Columns A-I = Dynamic Range "Numbers"
Rows 20-480

Example sample data from Range "Numbers":

ROW20 51 58 59 65 69 72 73 76 79
ROW31 50 51 58 72 73 76 79 80 81
ROW50 50 52 60 62 68 69 70 75 76
ROW75 53 54 59 60 62 69 70 72 73
ROW80 50 51 58 59 70 71 72 73 76
ROW83 51 53 65 67 68 69 78 80 81
ROW94 51 52 58 60 61 65 67 72 73
ROW99 50 53 57 62 63 68 70 71 73

Example Criteria:
Find the LAST occurrence of 72 AND 73 together and return the Date.

Regards,
Sam

--
Message posted via http://www.officekb.com