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)
yushang An empty string like "" does not equal a blank. That why you get FALSE. Turn it into this:
=LET(x,MAKEARRAY(2,2,LAMBDA(r,c,"")),x="") to get all TRUE.