Google Spreadsheet Post #1642
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May-20-2014
post by mcglk: (https://productforums.google.com/forum/#!mydiscussions/docs/zp_yDFZ3LY8)
Next non-blank cell in a range.
following is my convoluted solution based on my understanding of mcglk is intending to accomplish -- presented in the following is a solution without use of helper columns --
with the user of helper columns a much simpler formulation can be used