Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mac Mac is offline
external usenet poster
 
Posts: 213
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to extract aggregate values from PivotTable Ivanchain Excel Programming 1 January 23rd 08 05:58 AM
Finding Most Recent Values in Col1 -- Summing Matching Values Rothman Excel Discussion (Misc queries) 5 December 20th 07 08:19 PM
Aggregate values without using the pivot table or subtotal [email protected] Excel Discussion (Misc queries) 0 March 6th 07 01:42 AM
Finding values within text and substituting with alternate values. Bhupinder Rayat Excel Programming 3 January 24th 06 01:44 PM
How to aggregate values in a database Frank Excel Worksheet Functions 0 March 16th 05 01:15 PM


All times are GMT +1. The time now is 09:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"