Thread: using excel generate random numbers 1 to 52 without repeating
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default using excel generate random numbers 1 to 52 without repeating
Hello,

I suggest to take my UDF UniqRandInt from www.sulprobil.com.

It will help you even if you have two card decks (=104 cards) and if
each player can get card number 1..54 twice (but not more often!).

Regards,
Bernd

Reply With QuoteReply With Quote