Hello friends,
There are three columns, each column, 10 values, need to find the formula, which enable combinations, one value from column to give the amount to 20.
The rule is possible to use the value in Column A, only once, and in two other columns, there is no limit.
Without volatile functions,
The result should be 7 combinations.
I came to the result, with 108 characters without character {} at the beginning and at the end of the formula.
Some values are highlighted for illustration.
Good luck !
David
There are three columns, each column, 10 values, need to find the formula, which enable combinations, one value from column to give the amount to 20.
The rule is possible to use the value in Column A, only once, and in two other columns, there is no limit.
Without volatile functions,
The result should be 7 combinations.
I came to the result, with 108 characters without character {} at the beginning and at the end of the formula.
Some values are highlighted for illustration.
Good luck !
David
Attachments

8.8 KB Views: 47
Last edited: