Wednesday, May 29, 2013

yogi_Query Data In Responses Sheet And Pull Data From Select Columns Based On Latest Date In Ascending Order

                                          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,


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 :(
-------------------------------------------------------------------------------------------------------------------------------