Sunday, December 27, 2015

yogi_Pull First Non-Blank Cell From Rows Of Table B2:F And Table B2:F Of Sheet2

Google Spreadsheet   Post  #1997
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Dec-27-2015
post by  Infomation:!topic/docs/mJCxkq2aZhc;context-place=forum/docs
First Non-Blank Cell in Row
Hi Google Community,

I am looking for some assistance with a formula that would return the value of the first non-blank cell within a row for each row in a sheet, hopefully the solution is or can be an array formula so that results will be returned as new rows of data are added. Rows that do not contain any data would remain empty.

I have created a sample sheet with some data, hopefully it will help.

Regards, Michael.