RAND FUNCTION
 

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

RAND FUNCTION
 

Duplicates are possible:

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

Copy to 10 cells.

Biff

"NADTARVIN" wrote in message
...
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