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- mFPEf4dFRnSjc4eDVIV1pYT1FUOWVv akFqSlE&usp=sharing
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/
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.
-----------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment