View Single Post
  #3   Report Post  
Max
 
Posts: n/a
Default

One way ..

Assume the words are in A1:A10

Put in B1:
=INDEX(A:A,MATCH(SMALL(C:C,ROWS($A$1:A1)),C:C,0))

Put in C1: =RAND()

Select B1:C1, fill down to C10

Col B will return a random shuffle of the words in A1:A10

Press F9 key to regenerate a fresh shuffle

Freeze the results elsewhere with a copy paste special values elsewhere
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Beckbeck" wrote in message
...
I'm formulating a questionnaire with a number of stimulus words to be
presented. I want to be able to put them in random order for a number of
different documents