L
Larry
I have multiple consecutive rows that get information from every third row
earlier in the spread sheet, is there a way to reference my 2nd row to the
first row in a formula.
Example:
I have information in Column A Rows 1,4,7,10,13, ect......
I want row 300 to look @ A - Row 1, 301 @ 4, 302 @ 7, ect....
In A300 (=A1)
In A301 can I add a function referencing (=A1+3) in any way so that it would
add 3 to the reference cell A301 looks at to give the value of (=A4).
earlier in the spread sheet, is there a way to reference my 2nd row to the
first row in a formula.
Example:
I have information in Column A Rows 1,4,7,10,13, ect......
I want row 300 to look @ A - Row 1, 301 @ 4, 302 @ 7, ect....
In A300 (=A1)
In A301 can I add a function referencing (=A1+3) in any way so that it would
add 3 to the reference cell A301 looks at to give the value of (=A4).