Hello!
I have been trying to figure out an easy way to do this. As my "real problem" is a bit confusing, I'll try to explain what I'm trying to do with dices.
Let's say I have 5 dices, each with 10 sides, with numbers from 1 to 10. I want to get all possible combinations (100,000) in a spreadsheet, similar to what MarvinP provided in this thread: (cant link the thread yet... so excelforum.com/ excel-new-users-basics/1100218-how-to-input-all-combinations-for-6-dice.html)
However, although I could change it to count up to 10 instead of 6, my real problem doesn't involves, necessarily, sequential numbers. My "dice" could have the following numbers, for example: 1, 3, 5, 6, 8, 10, 11, 13, 15, 19 (instead of 1, 2, 3, 4...).
Is there any way that I could build a similar spreadsheet, but specifying the numbers of my dice?
Thank you in advance!!
- mucura
Bookmarks