Here is my request:
I have one question A1 with four possible answers. (A2,A3,A4,A5)
But this one will give me double results, for ex. A2,A3,A3,A2. I try with RAND function but no success.
Anybody have any idea how to solve this problem?
Thx
Here is my request:
I have one question A1 with four possible answers. (A2,A3,A4,A5)
But this one will give me double results, for ex. A2,A3,A3,A2. I try with RAND function but no success.
Anybody have any idea how to solve this problem?
Thx
Try
=CHOOSE(RANDBETWEEN(1,4),A2,A3,A4,A5)
@KjBox Not working I still have duplicate.
=CHOOSE(RANDBETWEEN(1;4); $A$2; $A$3; $A$4; $A$5)
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 91"]
[TD="width: 121"]question1[/TD]
answer 1
[/td]answer 1
[/td]answer 3
[/td]answer 4
[/td]
[/TABLE]
Attach a sample workbook and show exactly how you want to apply the random answers.
Don’t have an account yet? Register yourself now and be a part of our community!