Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using excel generate random numbers 1 to 52 without repeating
I want to shuffle a pack of playing cards using excel
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
How do I get excel to generate Random nos for my data? | Excel Worksheet Functions | |||
How can I generate random characters in Excel | Excel Discussion (Misc queries) | |||
Can I create a random order within a series of numbers in Excel? | Excel Worksheet Functions | |||
Generate random numbers between two values and with a given mean | Excel Worksheet Functions |