Andy Chaplin wrote:
Hi there Everyone
I have a problem with the calc formula RANDBETWEEN.
I have created a numbered list from 1 to 100 in column A. In column B is a
list of questions I want to select.
In another sheet I have used VLOOKUP and RANDBETWEEN in 10 sucessive rows to select 10 random items from the list. So far so good. The problem is that RANDBETWEEN allow duplicates (and I must say, they appear unusually frequently!).
The formula I used was:
=VLOOKUP(RANDBETWEEN(1;100);'other_sheet'.$A$6:$C$105;2)
Is it possible to select from a list randomly but without duplicates?
Any suggestions would be appreciated.
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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
