Determine what column to calculate data from

[psimatrix]

I am working on a spreadsheet and I need to have a column based on dat
from X previous columns. Explained another way:

Column D = (Column D - X Columns)

X = Spreadsheet2!A1


The usage of this is to try and calculate how many people unsubscrib
from a website in a given month (Column D) if the average user a membe
for X amount of months. So I need to "look back" X amount of months eac
month and determine how many users will be unsubscribing

 

[Jason Morin]

Try this in column D:

=OFFSET(INDIRECT("RC",0),,-Spreadsheet2!A1)

HTH
Jason
Atlanta, GA

 

[Harlan Grove]

Try this in column D:

=OFFSET(INDIRECT("RC",0),,-Spreadsheet2!A1)

....

Or save a function call with

=INDIRECT("RC["&-Spreadsheet2!A1&"]",0)