I select a value (1st number), then I need to find a second value located 5,
10 and 15 readings previous. The information is 90 rows long and 5 columns
wide. Because these values don't always show up at 5, 10 and 15 readings
apart, I have to keep looking until they do. The readings don't need to show
up together in a group. I need one result for 5, then another for 10 and
another for 15.

I've been using conditional formatting to highlight the two numbers in the
range of B2:F91 and counting out manually when the readings show up
togetherin the 5, 10 and 15 spans. Readings are being taken once a day, so
the range changes every day.

I've been looking at Match, IF, Offset and MMult, I think Match is out
because I can't figure out how to make it look for the last set first and
match two values at the same time. I'm thinking it's going to be a
combination in an array formula.

I'm working on macros and am picking up a little VBA, but I'm still mostly
lost.

Any assistance will be Greatly appreciated, Thank you.
--
Linda