ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Finding addends of an aggregate in a given set of values (https://www.excelbanter.com/excel-programming/408689-finding-addends-aggregate-given-set-values.html)

Mac

Finding addends of an aggregate in a given set of values
 
Hello,
I wonder if anyone solved a problem similar to this:

assume an aggregate X and a set of values a, b, c, ..., zz; I want an
algorithm to tell me:

To obtain the aggregate X, you can sum the available values like:
a + c + e + ... + x, or
a + e + g + ... + x, or
c + e + k + ... y,
..
..
..

I know there is an Excel template with VBA routines by Tsushar, but these
become inefficient when the number of values increases to a couple hundred.
Deos anyone know of a feasible solution for, like - 800 values in a set?


All times are GMT +1. The time now is 05:38 PM.

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