Home |
Search |
Today's Posts |
#1
|
|||
|
|||
problem solving
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |