Random Number Cell Filling
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
|