using excel generate random numbers 1 to 52 without repeating
I want to shuffle a pack of playing cards using excel
|
using excel generate random numbers 1 to 52 without repeating
Excel has no hands - would you care to elaborate?! Are you after 52 cells
(or 54 with 2 jokers) each containing a different value of card? "Norman" wrote in message ... I want to shuffle a pack of playing cards using excel |
using excel generate random numbers 1 to 52 without repeating
Nel post
*Norman* ha scritto: I want to shuffle a pack of playing cards using excel You can use these formulas from Ivano Chiappa, a very smart guy on microsoft.public.it.office.excel newsgroup: In D1 put: =INT(RAND()*(last-first+1))+first while in D2 put as an arry formula (i.e. with Ctrl + Shift + Enter instead of Enter): =INDEX(LARGE(IF(NOT(ISERROR(MATCH(ROW(INDIRECT("A" &first&":A"&last)),$D$1:D1,0))),0,ROW(INDIRECT("A" &first&":A"&last))),ROW(INDIRECT("A1:A"&last-first))),INT(RAND()*(last-first+1-ROW(A1)))) then you have to copy down till D52 (or D54 if you have also 2 jokers) where first mean the lowst number, in your case is 1, while last mean your highest value, so 52 or 54 if you have also 2 jokers -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
using excel generate random numbers 1 to 52 without repeating
In article ,
says... I want to shuffle a pack of playing cards using excel For several different options see Random Selection http://www.tushar-mehta.com/excel/ne...ion/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 |
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 |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com