RAND FUNCTION

N

NADTARVIN

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>
 
B

Biff

Duplicates are possible:

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

Copy to 10 cells.

Biff
 
Top