Hi there
Does anyone know where I can find a sample of an Excel Quiz question randomizer. I am attempting to create a multiple choice quiz with the capacity to randomly select 40 questions from a total selection of 120 questions.
I've got a handle on creating the questions but I'm struggling with the randomization part so would appreciate any help or samples that anyone has to offer.
Regards
Macquhele
use =RAND() at every of your 120 questions
then select SMALL(these_generated_numbers,X) where X = 1..40 as a designation of these to be included.
suggested approach is by VBA but one can do this with worksheet functions (but remember RAND numbers change every time the sheet is recalculated.
Hello macquhele,
I saw something very similar in this link: http://www.ozgrid.com/forum/showthread.php?t=148753
Maybe it could get you started in the right direction.
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
This might help you get started.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Try this...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks