Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
REach o fixed number from different combinations
I need to reach a number using different combinations from a number
of cells. For example cells filled in with numbers A:A100 and I need to know how excel can identify the cells who can be sum to reach a fixed number. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
REach o fixed number from different combinations
This is well-ex[;ained in:
http://www.tushar-mehta.com/excel/te...ues/index.html -- Gary''s Student - gsnu200824 "c_riss" wrote: I need to reach a number using different combinations from a number of cells. For example cells filled in with numbers A:A100 and I need to know how excel can identify the cells who can be sum to reach a fixed number. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
REach o fixed number from different combinations
Hi,
You can use the Solver tool, however, there are often multiple solutions to this kind of problem and Solver only returns one result. Consider 1 2 3 4 5 6 If the total I have is 7 what combination of numbers will give that result? 1+6 or 2+5 or 3+4 or 1+2+4 ..... -- If this helps, please click the Yes button. Cheers, Shane Devenshire "c_riss" wrote in message ... I need to reach a number using different combinations from a number of cells. For example cells filled in with numbers A:A100 and I need to know how excel can identify the cells who can be sum to reach a fixed number. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
All Possible Number Combinations | Excel Discussion (Misc queries) | |||
Excel how to be alerted when cells reach preset number? | Excel Worksheet Functions | |||
how to count the number of cells it takes to reach a certain sum | Excel Worksheet Functions | |||
Determine payback period to reach fixed dollar amount. | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions |