Link to home
Start Free TrialLog in
Avatar of Alexandre Takacs
Alexandre TakacsFlag for Switzerland

asked on

Pick best permutation of values to match a target value in a sum

Let assume the following table in Excel

a - 50
b - 20
c - 10

Open in new window

I'd like find the permutation of a+b+c+ (xxx) that would give me a sum closest to a given number (in my example above say my target is 60 so it would be a+c).

Any way to implement this in Excel ?

Avatar of byundt
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial