View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Sorting players of cards

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


"Pit" wrote in message
...
I have to draw some numbers from 1 to 80,i need to put a
form of application numbers, putting them to couples, they
are not had to repeat in the cycle of the program
Kindest regards
Peter