Random Question Paper Generator

[Harrytheb]

Greetings,

I am in the process of creating a random question paper and answer sheet generator. Tab 1 has the questions (ie 1. what is ....) in column A and the answers in column B. I have managed to generate 50 random questions out of 500 in column C (using - "=INDEX(A2:A500,ROUND(RAND()*COUNTA(A2:A500),0))". I copy the cell values from column C to tab 2 as a question paper.

1. I need help in stopping duplicate quetions on tab 1 column C in the above formula.
2. I dont know how the get the corresponding answers to questions from column B to column D. I then plan to copy the cell values from column D on tab 1 to tab 3 to give an answer paper.

These formulas are easy when you know how!! Can anyone help with this one? Many thanks in advance.
Rgds
Harry

[Melvinrobb]

There might be a better way, but the attached will work. The first column is a random number, and the second column is a rank for each Question, based on the random number. That way each question has a unique number between 1:500, and is randomly assigned.

[Harrytheb]

Melvinrobb, Thank you very much for this solution. Works fine in the format that I had in mind and removed one or two potential issues that I had in the back of my mind too. I love this forum!! Rgds Harry

[Rupal Arora]

Hello Harry,

As per your query you need to be stuck in this kind of hassle, you can simply segregate the duplicate question in th