Forum Discussion
SCAN returns #VALUE ERROR
What I am doing wrong here ?. This formula worked until yesterday but throws #Value error now.
Yes, It is numbers. Even this doesn't work. =SCAN(0,SEQUENCE(10),LAMBDA(a,v,a+v))
SanthoshKunder Works for me!
Not sure why it is inconsistent. It worked 2 times and stopped working 3rd time for me