How can I randomize digits in Excell?

A

An

For example: I have a row of 6 digits, number 1 to 6, which I want to
randomize over 30 trials... how can i do this?
I'm working with micr. excell 2003.
 
A

Ardus Petus

Try this (to be copied in a 30x6 range):
=INDEX($A$1:$F$1,1,INT(RAND()*6)+1)

HTH
 
Top