Sorting players of cards
-----Original Message-----
put 1 to 80 in A1:A80
in B1 to B80 put in
=Rand()
then sort both columns with column B as the sort key.
now you can take the firs "n" cells.
Regards,
Tom Ogilvy
Ok but i need a random beetwen 1 to 80, any vba code?
Thanks in advance
Pit
|