Thursday, December 26, 2013

yogi_Set Up Formula Using INDIRECT Function To Be Dragged Down

                                          Google Spreadsheet   Post  #1452
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-27, 2013
question by rand2002 (http://productforums.google.com/forum/?zx=wke6o1qgwz6q#!category-topic/docs/spreadsheets/z9nczi618hQ)
Dragging the =INDIRECT function down rows
https://docs.google.com/spreadsheet/ccc?key=0Avk95-mFPEf4dFRnSjc4eDVIV1pYT1FUOWVvakFqSlE&usp=sharing


In the above sheet, I had a simple function in column C that compared the changes between column D & E.   it was  =(D2-E2)/D2
Each day I add a column left of D and insert today's data.  Afterwards, I have to adjust column C to find the percentage change between column D & E again (because it adjusted D2 & E2 to E2 & F2 when i add a column left of D).


So today I found the INDIRECT function that wont adjust to E & F when I add a column left of D each day.  It works in the first Row when I add quotes around the cell reference, but I cant copy it down to the next row. 

by the way I cropped the sheet to only a few rows, the original has over 550 rows.

Got to be a short cut right?  Please and Thanks for the help.
-----------------------------------------------------------------------------------------------------------------------------------------