Random lists of questions in Excel 2003

  johnincrete 10:06 AM 10 May 13
Locked

I have a list of questions numbered 1 to 10 and I want to generate 4 lists in which these 10 questions occur randomly. I can see how to generate one random number using RAND but don't see how I can get a list.

The idea is that 4 teams of students can give answers to the questions but, at any one time, the questions are different so they can't copy from others.

Advertisement

This thread is now locked and can not be replied to.

Sony Xperia Z5 vs Xperia Z5 Premium vs Xperia Z5 Compact: What's the difference between Sony's new ?…

1995-2015: How technology has changed the world in 20 years

Get $800 of free online Nuke and VRay rendering from Google Zync

iPhone 6S preview: What to expect from Apple's next iPhone