Combinations calculator in excel??? Macro??
Hello all looking for a formula? or file? or macro? i am not excel smart at all so please excuse the wording. i think best way would to give example. any info would be greatly appreciated.
Ex. i have $30.00 and there are 10 action figures available for purchase. I must buy 3 with no more than my $30.00.
this would be based on having 10 options and needing to know which groups of 3 i could buy at or below $30.00.
choices- based on dollars
figure 1- $12
2 - 11.5
3 - 11
4 - 9.8
5 - 10.8
6 - 9
7 - 8
8 - 10.5
9 - 11.2
10- 12.4
Now i would like to show me what my options would be at or below 30.
(1,6,7 ; 4,5,6 ; etc etc.)
|