Random lists of questions in Excel 2003

  johnincrete 10:06 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.

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

Huawei P10 review

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

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now