RAND FUNCTION

[Guest]

I AM TRYING TO CREATE A LIST OF 10 RANDOM SAMPLES WITH TWO DIGIT NUMBERS FROM
A 5 X 5 MATRIX THAT I ALREADY CREATED. HOW DO I INPUT THE COLUMN, ROW AND THE
STARTING NUMBER>

 

[Biff]

Duplicates are possible:

=INDEX($A$1:$E$5,INT(RAND()*5+1),INT(RAND()*5+1))

Copy to 10 cells.

Biff