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. All the best Andy -- Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
