I have a tab called Record. Here are the cells it contains:
This repeats in cells A6-A10,A11-A15,etc.
In another tab called Graph I have the following in
cell B2 (cell B1: 0-.4)
The above formula works fine as it finds the first 0-.4 and gives me the
number in cell D. I would like a formula for cell B3 to find the next
occurance of 0-.4 and give me the number in the corresponding cell D.
Anyone know how to do it?
belive it is something like this (this is another formula in my
spreadhsheet but I can't follow it). I believe I could use the same formula
but just need to reference the Record tab instead of the Scores tab, B1
instead of Capitals, and the Q and S references change to something.