Allocating a dataset randomly to a fixed set

[flashb]

Hi there,

I have a set of 100 unique items, which I need to allocate randomly between 10 'names'. Each of the 10 names should be allocated an even number ie. 10.
Is there a fairly simple bit of code that can do this?

Any help would be appreciated.

Thanks in advance

AshB

 

[Rolliee]

Use random numbers to allocate:

numof = 100
newval = Int((numof * Rnd) + 1)

Use this for 90 with appropriate code and the remainder for the 10th group to the last man.

rollie@bwsys.net