Should mention that each time you hit <F9, you'll get a *new* random list.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"RagDyeR" wrote in message
...
What you're looking for is a random order without replacement (no
duplicates).

In an out-of-the-way location, say Z1 to Z20, enter the Rand function:

In Z1 enter:
=Rand()
and copy down to Z20.

With your original numbers in A1 to A20, in B1 enter:

=INDEX(A$1:A$20,RANK(Z1,Z$1:Z$20))

And copy down.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Big Rick" wrote in message
...
Hi Sheeloo
Many thanks for you reply.

This does work, but only to a small degree for my needs.
What I should of pointed out is that I needed all 20 numbers in col A to be
replicated in random order in col B.

The formula also gives gives me random REF# errors in some of the cells. I
cannot figure out why.

Perhaps you could help me a little bit further.
<-<-<-<-
Big Rick


"Sheeloo" wrote:

Try this in B1 and copy down to B20
=INDIRECT("A"&ROUND(RAND()*20,0))

"Big Rick" wrote:

Hello Folks,

This is my first post in about 2½ years, it's so good to be back.

In cells a1 to a20, I have 20 different numbers, obviously 1 number in
each
cell.
In cells b1 to b20, I would like those 20 amounts, but placed in
randomly.
All help gratefully received.

Your help is and always has been very much appreciated.
Thanking you in anticipation.
<-<-<-<-
Big Rick