Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|