Determine what column to calculate data from

  • Thread starter Thread starter psimatrix
  • Start date Start date
P

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
 
Try this in column D:

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

HTH
Jason
Atlanta, GA
 
Jason Morin said:
Try this in column D:

=OFFSET(INDIRECT("RC",0),,-Spreadsheet2!A1)
Click to expand...
....

Or save a function call with

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