Optimize list for payback <X

I'm a newbee... that needs help to solve what is probably a simple solution.

From the project list (below) I need to select those projects that will collectively optimize a payback of <2.

Save Cost Payback
$6,529.54 $16,273.66 2.492315534
$7,498.08 $11,419.03 1.522925978
$1,620.96 $8,606.71 5.309644576
$2,448.58 $6,102.62 2.492315534
$843.40 $2,812.14 3.334293892
$81.62 $1,800.96 22.06539638
$258.46 $788.96 3.052532531
$189.41 $690.03 3.643160492
$116.31 $691.44 5.94493762
$193.85 $591.72 3.052532531
$122.43 $562.62 4.595467733
$136.03 $453.57 3.334293892
$13.60 $468.85 34.466008
$192.83 $343.08 1.779201657
$174.12 $307.31 1.764903356

In the list i want to select the by paybaxk value the rows that collectivly deliver a payback equal to or less than x.



What does that mean?[/QUOTE]

Sure that will find rows with payback <2. But if the payback of those rows is 1.5 there may be X additional rows with a payback >2 that when included the payback of all rows remains <2. A sort command will not optimize the result. Below rows marked with "o" offer a payback result of 1.96 even though the payback for row 2 is >2. Retesting the result with row 3 (marked x) yields a payback result >2 (2.04 as shown in last row).

$7,498.08 $11,419.03 1.522925978 o
$6,529.54 $16,273.66 2.492315534 o
$2,448.58 $6,102.62 2.492315534 x
$1,620.96 $8,606.71 5.309644576
$843.40 $2,812.14 3.334293892
$258.46 $788.96 3.052532531
$193.85 $591.72 3.052532531
$192.83 $343.08 1.779201657 o
$189.41 $690.03 3.643160492
$174.12 $307.31 1.764903356 o
$136.03 $453.57 3.334293892
$122.43 $562.62 4.595467733
$116.31 $691.44 5.94493762
$81.62 $1,800.96 22.06539638
$13.60 $468.85 34.466008
$13.16 $468.85 34.466008
$13.63 $468.85 34.466008
$14,394.57 $28,343.08 1.969011926 o
$16,843.15 $34,445.70 2.045086578 x

Your probably correct. Thanks for the suggestion! ! ! Dah!

https://dl.dropboxusercontent.com/u/...erjo1_1.1.xlsm

No need to enable macro - unless you want to experiment.