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
No comments:
Post a Comment