I guess this would work in a similar manner as Solver, but where Solver tweaks cell values to equal a given total, I've got a set of cells and I need to find the combination that equals an amount in another cell. Is there a way to do this?
Find Combination Of Cell Values Equaling A Specified Total
-
-
-
Re: Is There A Feature That Finds A Combination Of Cell Values Equaling A Specified T
There is nothing built in afaik, rather like finding the number of invoice values tht equal a payment I imagine is what you want.
-
Re: Is There A Feature That Finds A Combination Of Cell Values Equaling A Specified T
That's exactly what I'm trying to do. Any ideas outside of a built-in feature?
-
Re: Is There A Feature That Finds A Combination Of Cell Values Equaling A Specified Total
Here is an example of using solver to find which cells match a total
-
Re: Is There A Feature That Finds A Combination Of Cell Values Equaling A Specified T
That's pretty sharp. Thanks for the help.
-
-
Re: Is There A Feature That Finds A Combination Of Cell Values Equaling A Specified Total
That is awsome JF.
-
Re: Is There A Feature That Finds A Combination Of Cell Values Equaling A Specified Total
Thanks Bryce and Colio but I can not take credit for initially creating it. I can not remember where I found it originally but made sure I kept a copy as I figured it would come in handy in the future. I think It was with a post on here a year or two back (someone trying to do a bank reconcilliation).
-
Re: Is There A Feature That Finds A Combination Of Cell Values Equaling A Specified Total
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!