Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to extract aggregate values from PivotTable | Excel Programming | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
Aggregate values without using the pivot table or subtotal | Excel Discussion (Misc queries) | |||
Finding values within text and substituting with alternate values. | Excel Programming | |||
How to aggregate values in a database | Excel Worksheet Functions |