How to shuffle questions in excel.

[southernsquid]

Looking for 2 things.
1) Need to shuffle basic questions with no answers. I have a bank of 200 questions and would like to shuffle and pull out 50 questions for a test.

2) Need to do the same thing but with Multiple Choice Questions. (1 Question and 4 answers, A,B,C, or D.

Thanks for the help. I am using Excel 2007. (The military is always behind)

 

[VoG]

ASAP-Utilities should help with this http://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=54&utilities=42&lang=en_us

 

[southernsquid]

OK, should I specify that I am not looking to buy anything? I couldn't install it on a military computer if I wanted too. Thanks anyways

 

[Smitty]

If you install the Analysis Toolpak (which is included with Excel, so you don't need to download anything) you might be able to do what you want with the Sampling tool. It'll show up on the Data tab-->Analysis.

HTH,

 

[southernsquid]

I dont have that option. Is there a formula I can use?

 

[VoG]

In another column

=RAND()

and copy down. Then sort both columns based on the RAND column.