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 <CCA3883A-FFA4-4368-94FB-03C4CE588C73@microsoft.com>,
William@discussions.microsoft.com 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
>
>
>
>
>