Hi,

1. Highlight A1:A20 and drag the fill handle to the right on column
2. In C1 enter =RAND() or =RANDBETWEEN(1,20) it really makes no difference
3. Fill this down to C20
4. Highlight B1:C20 and sort on C.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Big Rick" wrote:

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