Hi,

Well that worked - wasn't quite the way I was expecting to be able to do it,
but thanks! Can this guarantee that the numbers in column A will be unique?

Also, don't know if this is normal but the random numbers I generate in Col
A are all decimals, why's that?

"Bob Phillips" wrote:

Matt,

In A2, enter

=RAND()

In B2, enter

=RANK(A2,$A$2:$A$3667)

then copy A2:B2 down to row 3667.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Matt D Francis" wrote in message
...
Hi,

I have looked at the Random Number Generator Add-in and the =RAND function
but can't get either to do what I want (although I'm sure they can)

I have a range of cells in a single column (A2:A3667), and I want a list
of
random numbers to fill that range using the values 1:3666, using each
value
once and once only. Effectively randomising the row numbers.

How can I do this?

Cheers,

Matt