Weird Sequence Bug ??

[Emmanueld32]

I have seen a discussion in the forum dated 2021 about this weird behaviour (bug?) of the function Sequence: Sequence(Randbetween(1,50),1) gives a #Spill! Error in Excel 365 most of the time. Sequence(A1,1) when A1=Randbetween(1,50) also gives a #Spill! error most of the time.
I was hoping that this would be solved by now, but at least for me, it is not working. About 80% of the time, I get a #Spill! error, even if there is only a single formula in the whole sheet!
Does anyone has the same bug and is there a workaround?
Thanks
Emmanuel

 

[Fluff]

It's because Randbetween is volatile & as far as I know, there is no work-round.

 

[Fluff]

Have a look here under Indeterminate size How to correct a #SPILL! error - Microsoft Support

 

[Emmanueld32]

Ah !!! I didnt know ! Thanks a lot !

 

[Fluff]

You're welcome & thanks for the feedback.

 

[FormR]

Hi, you might be able to work with something like this depending on what you are ultimately trying to do.

=LET(RND,RANDBETWEEN(1,50),SEQ,SEQUENCE(50),IF(RND<SEQ,"",SEQ))