Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TOTAL OF A RANGE SHOULD BE
Is there a function or formula that can calculate which numbers add up to
another. for example: 5 6 7 8 I want the combination of numbers that will give me 21. In other words I know what the answer should be, just need to find out which combination of numbers will give me the answer. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TOTAL OF A RANGE SHOULD BE
see:
http://www.tushar-mehta.com/excel/te...ues/index.html -- Gary''s Student - gsnu200852 "JOSEPH WEBER" wrote: Is there a function or formula that can calculate which numbers add up to another. for example: 5 6 7 8 I want the combination of numbers that will give me 21. In other words I know what the answer should be, just need to find out which combination of numbers will give me the answer. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TOTAL OF A RANGE SHOULD BE
JOSEPH WEBER wrote...
Is there a function or formula that can calculate which numbers add up to another. *for example: 5 6 7 8 I want the combination of numbers that will give me 21. *In other words I know what the answer should be, just need to find out which combination of numbers will give me the answer. No function or formula can do this. You need to use Solver or VBA. Here's a link to a VBA approach. http://groups.google.com/group/micro...19858047398beb |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TOTAL OF A RANGE SHOULD BE
Excel function and formula can't do this, try using the Solver solution
see this link, a solver solution provided by Peo Sjoblom http://groups.google.co.uk/group/mic... ublic.excel.* -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "JOSEPH WEBER" wrote: Is there a function or formula that can calculate which numbers add up to another. for example: 5 6 7 8 I want the combination of numbers that will give me 21. In other words I know what the answer should be, just need to find out which combination of numbers will give me the answer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Total A Range | Excel Worksheet Functions | |||
Finding 'total' in range | Excel Worksheet Functions | |||
how to get a total to add up a range | Excel Worksheet Functions | |||
finding a range of dates to total | Excel Discussion (Misc queries) | |||
How do I get the total of a range of cells that are in another she | Excel Discussion (Misc queries) |