View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Flamikey[_6_] Flamikey[_6_] is offline
external usenet poster
 
Posts: 1
Default Generate all possible combinations from three data sets?


I want to build a table that lists all possible Blackjack initial han
combinations with a dealer and one player. This means I am onl
looking for the first 3 cards and I am making the assumption there is
full deck. So I have 3 sets of {2,3,4,5,6,7,8,9,10,J,Q,K,A} and ther
should be 2,197 possible combinations (suits are not considered). I
there an easy formula to generate all of the possible 2,197 hands?
Thanks

--
Flamike
-----------------------------------------------------------------------
Flamikey's Profile: http://www.excelforum.com/member.php...nfo&userid=461
View this thread: http://www.excelforum.com/showthread.php?threadid=26779