I am looking for a way for Excel to generate, or help me generate 7 (for example) numbers in any range i specify. (I find that it helps to visualize a box containing 7 "hidden" balls that once pulled, cannot be put back in the box.)
Rule #1: each number is unique
Rule #2: the sum of any combination of 1,2,3,4,5 or 6 of those numbers may not equal any of the numbers on the balls. (so...if there's a '7-ball' in the box, you cannot also have a '3-ball" and a 4-ball" in the box with it, nor can you have a '1'-ball, a '2' ball, and a '4' ball all in the box with it.)
Rule #3: the sum of any combination of those numbers may not equal the sum of any combination of any of the OTHER numbers. (so if you have a '5-ball' and a '6-ball' in the box (5+6=11)... you cannot also have a '3-ball', a '1-ball' and a '7-ball' in the box 3+1+7=11).
But... it does not matter that the sum of the first, third and sixth ball equals the sum of the second, third, and fifth ball, since the third ball may only be pulled out of the box once.
I just realized a totally different way of looking at it - If this was a game of pocket billiards/pool with 7 balls on the table - and every ball pocketed would award that ball's numerical value to the person who got it in, it would be numerically impossible for any game to end in a tie, no matter how many players were playing or how many balls each of them sunk.
Many thanks for your help. OH, And if this becomes a new billiards game in the process, I promise to share all profits 50/50!
Thanks!
Rule #1: each number is unique
Rule #2: the sum of any combination of 1,2,3,4,5 or 6 of those numbers may not equal any of the numbers on the balls. (so...if there's a '7-ball' in the box, you cannot also have a '3-ball" and a 4-ball" in the box with it, nor can you have a '1'-ball, a '2' ball, and a '4' ball all in the box with it.)
Rule #3: the sum of any combination of those numbers may not equal the sum of any combination of any of the OTHER numbers. (so if you have a '5-ball' and a '6-ball' in the box (5+6=11)... you cannot also have a '3-ball', a '1-ball' and a '7-ball' in the box 3+1+7=11).
But... it does not matter that the sum of the first, third and sixth ball equals the sum of the second, third, and fifth ball, since the third ball may only be pulled out of the box once.
I just realized a totally different way of looking at it - If this was a game of pocket billiards/pool with 7 balls on the table - and every ball pocketed would award that ball's numerical value to the person who got it in, it would be numerically impossible for any game to end in a tie, no matter how many players were playing or how many balls each of them sunk.
Many thanks for your help. OH, And if this becomes a new billiards game in the process, I promise to share all profits 50/50!
Thanks!
