Tuesday, February 15, 2011


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

joshua.kuswadi said ...
How do I conditionally check a multi dimensional array and return a 1-dimensional result?
In the following solution I used the split function in cell B1 ... one formula should do it all, but because of a quirk in the split function where only first cell of the first row gets populated, I had to use one more formula in the cell C1 as delineated in the Result1 sheet, and in Result2 sheet I have used a single formula in cell B1 -- however in this case the first row is empty