R
RagDyeR
It's considered bad manners when you don't use the body of the post for your
actual question.
BUT -
This is for a random list "without replacement" - (no duplicates).
Numbers in A1 to A138.
In an out of the way location, say Z1, enter this formula:
=Rand()
And copy down to Z138.
Enter this is B1:
=INDEX(ROW($A$1:$A$138),RANK(Z1,$Z$1:$Z$138))
And copy down as many rows as you wish to retrieve random numbers.
Now, each time you hit <F9>, you'll get a new list.
***OR***
You could copy that Rand() formula down Column B,
Select A1 to B138,
And sort, using Column B as the sort key.
Then, use the first 15 rows for your random data.
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
news[email protected]...
actual question.
BUT -
This is for a random list "without replacement" - (no duplicates).
Numbers in A1 to A138.
In an out of the way location, say Z1, enter this formula:
=Rand()
And copy down to Z138.
Enter this is B1:
=INDEX(ROW($A$1:$A$138),RANK(Z1,$Z$1:$Z$138))
And copy down as many rows as you wish to retrieve random numbers.
Now, each time you hit <F9>, you'll get a new list.
***OR***
You could copy that Rand() formula down Column B,
Select A1 to B138,
And sort, using Column B as the sort key.
Then, use the first 15 rows for your random data.
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
news[email protected]...