Hello everyone, first time trying this, I hope someone can help. I have simplified the problem as much as possible. I have the below table (as an example):
12.png
Column A has correct statements, and columns B and C do not. I want to randomly select 2 statements, randomly. For the first statement, I am using:
=IF(RANDBETWEEN(1,3)=1,INDEX(A1:A5,RANDBETWEEN(1,ROWS(A1:A5))),IF(RANDBETWEEN(1,3)=2,INDEX(B1:B5,RANDBETWEEN(1,ROWS(B1:B5))),INDEX(C1:C5,RANDBETWEEN(1,ROWS(C1:C5)))))
So there is a 1 in 3 chance that the statement comes from one of the columns. But I am stuck on how to select the second statement. This is because I do not want it to come from the same row as the first statement. So if the first statement (true or false, does not matter) is from row 1 about frogs, I do not want the second statement to be about frogs.
Any ideas? I am not tied to my way of selecting the first statement. If anyone can think of an easier way to select both (either separately or combined) I would be very grateful.
Bookmarks