View Single Post
 
Old 01-23-2015, 11:58 AM
mkuderik mkuderik is offline Windows 8 Office 2007
Novice
 
Join Date: Jan 2015
Posts: 1
mkuderik is on a distinguished road
Default 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.)
Reply With Quote