- Jun 29, 2005
- 66
- 0
- 52
Hi, after a bit of help, what i am trying to do is design a random question generator for somethign i am doing at work, has to be done within access or excel. This is what i am trying to achieve..
100 Questions, broken down into 5 categories. and it will lets say choose 2 random questions from each section, to make a small exam.
Anyone available to help as have been scratching my head, have workd out how to create a whole random number, and also messed about with LOOKUP and VLOOKUP but cant seem to get that working properly, let alone figured out how to ensure it doesnt pick the same question twice in the same run.
anyone help :x
thanking you in advance
100 Questions, broken down into 5 categories. and it will lets say choose 2 random questions from each section, to make a small exam.
Anyone available to help as have been scratching my head, have workd out how to create a whole random number, and also messed about with LOOKUP and VLOOKUP but cant seem to get that working properly, let alone figured out how to ensure it doesnt pick the same question twice in the same run.
anyone help :x
thanking you in advance