Google Spreadsheet Post #1217
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May 29, 2013
user user Alfred Lazarus (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/how-do-i/desktop/qJyhoqXa6LE)
Formula to get latest Value
Hi All,
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May 29, 2013
user user Alfred Lazarus (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/how-do-i/desktop/qJyhoqXa6LE)
Formula to get latest Value
Hi All,
i am having issues trying to run an array formula to return the most recent date and status for a particular value. The current log sheet should pull the lastest date it was updated and the latest status, i tried using an array formula it works for single cells but I have to drag it each time there is a new entry, how can I get the formula to automatically get applied to all cells in Current Log A column, pulling data from the Node history sheet?
Thanks Guys,
PS: I tried using Yogi Anands formula from another post but that dint help either :(
-------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment