C
ClayTele
Here is my question/setup
In column A i have a list of dollar amounts. In a cell in Column B I have
my a speciifc dollar amount i'm looking to extract from column A.
My quesiton is: Is there a forumla or solver that can give me the best
combination of dollar amounts in column A that would get me closest to the
amount in my cell in coumn B, say within 5%?
EXAMPLE: In order to get 7, i could use 2+5 or 3+4 (obviously more
complicate when using dollarsa & cents)
Column A Column B
1 7
2
3
4
5
Thanks!
In column A i have a list of dollar amounts. In a cell in Column B I have
my a speciifc dollar amount i'm looking to extract from column A.
My quesiton is: Is there a forumla or solver that can give me the best
combination of dollar amounts in column A that would get me closest to the
amount in my cell in coumn B, say within 5%?
EXAMPLE: In order to get 7, i could use 2+5 or 3+4 (obviously more
complicate when using dollarsa & cents)
Column A Column B
1 7
2
3
4
5
Thanks!