Forum Discussion
TOCOL/TOROW Treat Thunks as Errors
I just reported a bug to Excel in which the TOROW and TOCOL functions, if asked to delete errors, will also delete valid thunks. ISERROR returns FALSE when presented with a thunk, so, arguably, TOCOL...
Why something like
=LET(th, VSTACK(LAMBDA(4)), TOCOL((@th)(),2) )
=LET(th, LAMBDA(SCAN(0, SEQUENCE(4), LAMBDA(a,v,IF(v=3, NA(), a+v)))), TOCOL( th(),2) )doesn't work?