RANDBETWEEN(1,11) but not 6?

Question

I'm trying to use RANDBETWEEN(1,11) but omit 6 and then drag it down. I don't know how to keep excel from including 6 as a random result?

Answer 1

maybe something like this:

=CHOOSE(RANDBETWEEN(1,2),RANDBETWEEN(1,5),RANDBETWEEN(7,11))

Answer 2

Try,

=choose(randbetween(1,10),1,2,3,4,5,7,8,9,10,11)

As you can see 6 is not included in the list of random numbers.