1
votes

I have successfully used a formula for randomly selecting cell contents in a range of adjacent columns using the following formula:

=INDEX(L3:Q3, RANDBETWEEN(1, 6))

I would now like to randomly select cell contents from one of two columns which are not adjacent. How can I make adapt the below formula to accomplish this?

=INDEX(I3,R3, RANDBETWEEN(1, 2))

1

1 Answers

2
votes

Use CHOOSE:

=CHOOSE(RANDBETWEEN(1,2),I1,R1)