Prev: Create a formula with a moving cell
Next: I have 138 numbers, how do i get 15 random numbers from my dat
From: Stan on 16 Mar 2010 20:15

From: RagDyeR on 16 Mar 2010 21:14
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!
=====================================================


"Stan" <Stan(a)discussions.microsoft.com> wrote in message
news:DFF74ACE-126D-4A68-BBCB-39771AD1D30E(a)microsoft.com...


 | 
Pages: 1
Prev: Create a formula with a moving cell
Next: I have 138 numbers, how do i get 15 random numbers from my dat