Any Excel/Access Guru's out there?

[Perrin]

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

 

[Far]

i know you said it has to be done in excel/access, but ive made a full website which will do exactly what you want in html/php/mysql if its any use at all?

no idea how to do it in access/excel tho sorry.

 

[jasper]

http://www.mrexcel.com/forum/index.php

 

[Perrin]

Thanks Jasper, was a link to a great website

 

[jasper]

yep,, helped me out pretty quick with a problem i couldnt figure out