1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Poker Hand-Dealing Simulation

Discussion in 'Excel Challenges' started by XLPadawan, Aug 2, 2017.

  1. XLPadawan

    XLPadawan Member

    Messages:
    47
    Assumptions:
    - there are 4 players
    - each player receives 5 random cards from a standard 52-card poker deck
    - AH, 2H, 3H, ..., JH, QH, KH <= Ace of Hearts, 2 of Hearts, and so on
    - AD, 2D, ... Diamonds
    - AS, 2S, ... Spades
    - AC, 2C, ... Clubs

    Feel free to take some liberties with this:
    Recalculating the sheet (F9) should "reshuffle" the deck and "redeal" the cards.

    You can reshuffle and redeal however you like. My solution utilizes sheet recalculation.
  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    10,533
    Most people setup a list of 52 Random Numbers
    Then apply a card to each number
    by looking up ie: cards 1 to 5 you have 5 random cards
    player 2 gets 6 to 10 etc
    XLPadawan likes this.

Share This Page