Finding addends of an aggregate in a given set of values

M

Mac

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

writing a value to a particular cell from function 3
Fill array with Values 4
e-mail a range of cells as the body 7
Finding the weighted average of text that have been given values 1
Randomize from set of values 9
Parsing thru columns to find the last number 2
Vlookup Mutiple Values 1
Find value in sheet 1 and copy matching row from sheet 2 1

Top