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   Dec-27, 2013
question by rand2002 (!category-topic/docs/spreadsheets/z9nczi618hQ)
Dragging the =INDIRECT function down rows

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.