• 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...

  • 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

XLPadawan

Member
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.
 
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
 
Back
Top