| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a macro in excel so that it can generate a list ofunique records using all permutations and combinations of the data in eachrow ad column | Excel Discussion (Misc queries) | |||
| Combinations in a string of data | Excel Worksheet Functions | |||
| Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
| How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
| generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
![Flamikey[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
