Monday, October 28, 2013

yogi_Extract The Entry In Last Or LastButSpecified Column Of A Specified Row For Open Ended Set of Entries

                                          Google Spreadsheet   Post  #1402
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct 28, 2013
question by John Carlin (http://productforums.google.com/forum/?zx=2c7u5pnoh2lj#!searchin/docs/John$20Carlin/docs/OGWBx-gHa4c/5fHCk5RFLugJ)
How to find the last cell value at the end of a specific row
Hi,

I have a Google Spreadsheet which is adding a new column each month. I need to create a formula which finds the last value at the end of row 191. Is it possible to create a formula which can sit in column B, specifically B191, which is able to automatically reference the last cell at the end of row 191?

Thanks in advance,

John
---------------------------------------------------------------------------------------------------------------------------------------------------