Friday, October 26, 2012

yogi_Identify Last Row Of A Non-Empty Row For each Column Of A Table


                                           Google Spreadsheet   Post  #828
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Oct 26, 2012
user esmithnola said: (http://productforums.google.com/forum/?zx=r3nme9qg99cb#!category-topic/docs/spreadsheets/GBML1XItLHw)
Function to identify last row of a column that's not empty
I've got a sheet like:

Date              A          B         C
2012-10-24     x                      x
2012-10-25                  x         x
2012-10-26     x

I'd like a way to determine the last date for each of A/B/C columns that's checked, e.g.:

                  10-26     10-25   10-25

I think if I could get the row number, I could figure out how to get the data.

Any suggestions?

-Dave
----------------------------------------------------------------------------------------------------
following is a solution to the problem