Thursday, August 11, 2011

yogi_Operate On Top And Bottom Cells Of A Range Of Interest

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

SuperUser said:
Add top and bottom of a column (not whole column)
I have several spreadsheets with different length columns of numbers. I want to subtract the top number (always in row 2) from the last number in the column, which could be in any row. Ex: If the list goes from F2 through F10, and is empty, I want =F10-F2. If the list goes from G2 through G14, and G15 is empty, I want =G14-G2).
What I really need is a way to identify the bottom filled cell (the next cell will always be empty). Anyone know how to do that?