Hello,
I am trying to create a quiz generator that will pull 10 random non duplicate questions from a question bank. I was able to get a random question from the bank by using this forumula: =INDEX(A2:A500,ROUND(MRAND()*COUNTA(A2:A500),1))
How can I get this formula to only give me a question that is in the same row as a specified category? Any help would be greatly appreciated!
I am trying to create a quiz generator that will pull 10 random non duplicate questions from a question bank. I was able to get a random question from the bank by using this forumula: =INDEX(A2:A500,ROUND(MRAND()*COUNTA(A2:A500),1))
How can I get this formula to only give me a question that is in the same row as a specified category? Any help would be greatly appreciated!