I have 40 questions which i want arranging into 6 sets of 15 questions. To do
this i thought i would randomly generate the numbers 1 to 40 15 times and
then repeat this. The problem i am getting is i keep on getting some numbers
repeating in the sequence. I am using the following code - =RAND()*(40-1)+1.
This works but i can't have the same question appearing twice.
Anyone know how i can adapt this to suit my needs?
Bookmarks