CODEWITHSUNDEEP
excelreferenceexcel-formulavba
user2872162
user2872162

Reputation: 5

Excel: Referencing a cell using a function

I hope i can explain this clearly, I am trying to compile data and the machine that i get the data from has 7 rows in between the values I need. Therefore to compile I write: 

Cell1 = A13 - B13
Cell2 = A13(+7) - B13(+7) = A20 - B20
Cell3 = A20(+7) - B20(+7) = A27 - B27
Etc.....

Is there a way to write a reference using a function? In this case: A(x+7)

Note: In this example the B column is just a "control value" that I have to subtract from A which is my "sample value"

Upvotes: 0

Views: 65

Answers (1)

Scott Craner
Scott Craner

Reputation: 152450

You could use:

=INDEX(A:A,13+((ROW(1:1)-1)*7))-INDEX(B:B,13+((ROW(1:1)-1)*7))

And copy down as need be.

Upvotes: 2

Related Questions