James Knott wrote:
You cannot have a truly random number, if you eliminate dupes. A random
number means that any number is valid in any order, even if it's been
used before. A random number generator cannot, by definition, consider
what numbers have been previously issued. All you can do, is pull a new
number and check for dupes.
Try my suggestion:
A1:A100: =RAND()
B1:B100: =RANK($A1;$A$1:$A$100)
C1:C100: =INDEX('other_sheet'.$A$6:$C$105;$B1;2)
or =INDEX('other_sheet'.$B$6:$B$105;$B1)
and for the very unlikely case of duplicate randoms in column A:
D1:D100: =COUNTIF($B$1:$B$100;$B1)
E1:
=IF(SUM($C$1:$C$100)>ROWS($C$1:$C$100);HYPERLINK(".uno:calculate";"DUPES
FOUND - Click Me!");"")
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
