Forum Discussion
Why this formula does not work?
Hi guys, Have look at this formula, it keeps returning #VALUE! error, what's the wrong? Many thanks! =LET(
x,"S"&SEQUENCE(5),
REDUCE(,x,LAMBDA(a,v,
LET(t,MAKEARRAY(10,1,LAMBDA(r,c,1)),t)))) ...
OliverScheurich I've double checked, it do return error. Any thing related to Excel version? I'm using Office 365, the Excel version is 16.0.16130.20298.