Thread
:
How to generate sets of random numbers without having duplicates
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Tushar Mehta
Posts: n/a
How to generate sets of random numbers without having duplicates
See
Random Selection
http://www.tushar-mehta.com/excel/ne...ion/index.html
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
I am trying to generate a set of random numbers. I have a set of 32 numbers
and I want to randomly select 40 groups that have three numbers between 1 and
32 without having duplicates within a group.
I tried using the rand between function, but one group had 2 numbers the
same, i.e. (7, 30, 7). I don't care if the different groups have numbers
that are the same or have the same three randomly selected numbers, I just
don't want one group having two numbers the same. Any help would be
appreciated. Thanks
Reply With Quote