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 ?

ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

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