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    Oct 26, 2012
user esmithnola said: (!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?

following is a solution to the problem