You're making me feel old!<bg

Glad to help and appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Big Rick" wrote in message
...
Hi RagDyer
Yours was the one that worked best and was the simplest for me, so have
used
your formula. I remember you from the 'olden days'! Many thanks to you.

My many thanks also to Shane, James, and Sheeloo for your help.
It is very much appreciated from all of you.

Best regards
<-<-<-<-
Big Rick


"RagDyeR" wrote:

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