Ive used the following formula to write out the numbers 1-4 in random order:
=ARRAY_CONSTRAIN(UNIQUE(BYCOL(SEQUENCE(1,50),LAMBDA(r, RANDBETWEEN(1,4))),1),1,4)
Now I need make sure the number 1 always appear on position 1,2 or 3. How can I achieve this?
I’ve tried a few different approaches but no luck.
New contributor
Magnus Ekermann is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.