ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combination equalling total (https://www.excelbanter.com/excel-discussion-misc-queries/38182-combination-equalling-total.html)

S. Mac

Combination equalling total
 
I have one large number. I also have numerous other numbers. I know that
some combination of the numerous numbers equals the large number. Is there
formula/function that would tell me which of the numbers this is?

Anne Troy

The only code I'm aware of that does this is he
http://www.mrexcel.com/pc09.shtml

*******************
~Anne Troy

www.OfficeArticles.com


"S. Mac" <S. wrote in message
...
I have one large number. I also have numerous other numbers. I know that
some combination of the numerous numbers equals the large number. Is there
formula/function that would tell me which of the numbers this is?





All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com