Forum Discussion
Solved
How to make an blank array?
Hi guys, I've tried with the following formula to make a blank array but in vain =LET(x,MAKEARRAY(2,2,LAMBDA(r,c,"")),ISBLANK(x)) So what should I return in the LAMBDA to make the x a blank...
Below is an example of a data transformation using blank values within a pivoted array.
Note for display in the grid null strings are used:
MATRIX(row,col,val,"")
but for arithmetic calculations, blank values are used instead::
MATRIX(row,col,val)
Patrick2788 They are not the true blanks. ISBLANK(EXPAND("",2,2,"")) return {false,false;false,false}
- What's the goal in returning 'true blanks'?
I had tried this same exercise to gain a better understanding of the formula language for building lambdas, since one often needs to account for null inputs. ISBLANK can be contrasted with ISOMITTED which returns a single FALSE value when given an array of blanks but does returns TRUE for the missing definition above.
