listing the 2, 598, 960 different poker hands in separate cells

Let's say My criteria is :
1 2 3 4 5 6 7 8 9 10 J Q K A (13 ranks of cards)
s c d h (4 different suits...s=spades c = clubs,etc)
5 would be the number of draws of 1 card to make a poker hand

How would I go about listing the 2, 598, 960 different poker hands in separate cells?

I would really appreciate any kind of help that helps me get this done.

thanks,
Chico

I think you will have problem making the 2,6 mill pokerhands fit into the 65536 rows in Excel.

Originally Posted by Max, Singapore

This should deliver it for you ..

Save this sample from my archives to a folder & open the file:
http://savefile.com/files/518493
MyrnaLarson_Combination_Permutation.xls

In Sheet1,

Put this in A3, copy down to A54:
=INDEX({"s";"c";"d";"h"},INT((ROWS($1:1)-1)/13)+1)&"-"&INDEX({2;3;4;5;6;7;8;9;10;"J";"Q";"K";"A"},MOD(ROWS($1:1)-1,13)+1)

The above will auto-list the full 52 "cards" into A3:A54, viz:

s-2
s-3
s-4
...
h-Q
h-K
h-A

Then input in A2: 5
(as you want sets of 5 from 52)

Input in A1: C
(C = combination)

Re-select cell A1, then press the button: ListPermutations

Leave it to run overnight. You should get the desired 2.6* mil "poker hand" returns in a new sheet in the morning.
*COMBIN(52,5)

I am not sure what I am doing wrong but as soon as I hit the button I get "run time error 1004"

I already had it on my hard drive. I copied the formula into cell A3 and it was displayed in cell A3 as tex showing the exact thing I copied. It did not turn the cell into s-2, so I hit [F2] and hit enter again and I got something to the effect invalid...do you accept to correct proposed change to fix formula? So I hit enter and it gave me the s-2 in the cell. I copied down but the formula put s-2 in all the cells down to cell A54. I think there is a typo in the formula somewhere. Could you have a look?

thanks a bunch for your help so far,
Chico

I clicked on the link you just provided and got this :

File not found...

There was an error retrieving your file.
The file may not be on this server.
Please check the address and try again.


p.s. you wanted to know why I wanted all these hands...I am testing a vlookup from any possible combination of poker hands. I realise it might be easier just to convert the results of a poker hand to something like "two pair, kings and 2's with ace kicker instead of kc,kh,2s,2d,ah since the latter has many other possible kings and twos combos but I am also checking other things that go along with a large data worksheet.

2, 598, 960 hands? just out of interest where does this figure come from?
for example AAAAk down to AAAA2 there are only 12 ways of getting that it doesnt matter what suit the other cards are.
similarly for
2 3 4 5 6 its the same hand as long as one card is off suit

ah but the question is "hands" not all the ways of achieving them!
e.g.a pair of 10's
there are only 6 ways of getting that.... but all 6 ways = one hand

Originally Posted by Chico

Let's say My criteria is :
1 2 3 4 5 6 7 8 9 10 J Q K A (13 ranks of cards)
s c d h (4 different suits...s=spades c = clubs,etc)
5 would be the number of draws of 1 card to make a poker hand

How would I go about listing the 2, 598, 960 different poker hands in separate cells?

I would really appreciate any kind of help that helps me get this done.

thanks,
Chico

i'm running excel 2003, if you want to list all hands, attach this macro to a button on a blank sheet and hit go (look online to see how to put a macro to a button).... this will list all hands like "1.2.3.4.5" where each # corresponds to a different card (1 - 52). all you need to do then is to assign a # to each card (1-52) and 1.2.3.4.5 changes to A.2.3.4.5 spades.... let me know if u have questions: [email protected] (btw... takes about 2 hours to run this macro as there are over 2.5 million hands!)

Please Login or Register  to view this content.

Have you been able to generate all 2, 598, 960 poker combinations in excel? If so, can you please share with me. Your help will be much appreciated.