Alexandre Takacs

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
(...)
```

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.