Google Spreadsheet Post #1997
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec-27-2015
post by Infomation:
https://productforums.google.com/forum/#!topic/docs/mJCxkq2aZhc;context-place=forum/docs
First Non-Blank Cell in Row
Hi Google Community,
https://productforums.google.com/forum/#!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.
https://docs.google.com/ spreadsheets/d/ 1Yv5kDnM07xb40rWiKWZUCyCS20EL_ GDEuPGuI4FsM6w/edit?usp= sharing
Regards, Michael.
--------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment