How generate word list form separate worksheet

[joshlee]

Hi
Can I would like to paste a list of words into one worksheet, and then on another worksheet (tab) have those words randomly generated. Is this possible?

cheers

Josh

 

[Special-K99]

Here's one way

in A1:A10 place your list of words

in B1:B10
=RAND()

in C1:C10
=INDEX(A$1:A$10,MATCH(SMALL(B$1:B$10,ROW()),B$1:B$10,0))

This will generate random words without repeats, ie it will sort the list into a random order.

Use F9 to regenerate the random words

 

[joshlee]

Hi Thanks for you reply, that is almost exactly what I want…except can I make the C1:C10 result happen on a second worksheet?