Sunday, August 11, 2013

yogi_Extract The Most Recent Non-Blank Entry For Each Column

                                          Google Spreadsheet   Post  #1326
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 11 2013
user Kristof Anderson (http://productforums.google.com/forum/?zx=tswnkbvc9ab#!category-topic/docs/spreadsheets/quAi27dyd5I)
How to have a cell formula "look up" to most recent data entry?
For the following three types of data in columns, what formula(s) would you use to have a cell look up and display the bottom most entry?


Datetextvalue

8/1PT1355

8/3T9152

8/7
66

8/8


8/9









what formula to:


look up above and display most recent data???




for example:8/9T9166
---------------------------------------------------------------------------------------------------------