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
Bookmarks