Hi,

In cell A1 type =RAND() and copy that down to A100. In cell B1 type:

=MATCH(LARGE($A$1:$A$100,ROW()),$A$1:$A$100,0)

and copy that down to B100.

Now in column B you should have numbers 1-100 that are unique and in
random order.

Of course there is a slight change that Excels RAND function returns
same number twice or more in a group of hundred, but that change is
something like 1:1E13.

- Asser


--
Jazzer
------------------------------------------------------------------------
Jazzer's Profile: http://www.excelforum.com/member.php...fo&userid=4464
View this thread: http://www.excelforum.com/showthread...hreadid=276584