•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Unpredictable #SPILL! error. Solution?
=SEQUENCE(RANDBETWEEN(1,10)) placed anywhere in a completely empty worksheet produces #SPILL! error about half of the times.
To see which random numbers are problematic, use =RANDBETWEEN(1,10) in A1 and =SEQUENCE(A1) in B1. Then it turns out that every randomly chosen number between 1 and 10 in A1 sometimes produces #SPILL! in B1 and sometimes produces a correct sequence.
How to solve this?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#SPILL
#SEQUENCE
#RANDBETWEEN
#Excel
#error
#worksheet
#formula
#random
#function
#A1
#B1
#number
#solution
#problem
#bug
#empty
#unpredictable
#cell
#output