Forum Discussion
Makearray within formula
I am trying to get the minimum value in an array that is generated using a formula. I would like to do this in one cell using MAKEARRAY, something like "=MIN(MAKEARRAY(10,1,LAMBDA(a,b,IFERROR(IF(a=""...
interesting. what is meant by "auto-lifting issue" and when/where else does this happen?
More about auto-lifting is here Yellow (lambdadays.org), "Auto-lifting/coercion" slide.
Usually it doesn't work in combination of some "old" functions and dynamic arrays, for example
Sometimes with named formulae. To force it, if reference adding of plus +range helps, if an array add something to it as here with +0