Brain Fry: Data Set Sum Compiling

  • Thread starter Thread starter Phaedrusz
  • Start date Start date
P

Phaedrusz

Good morning all,

Been working on this for about a week and have run out of ideas.

I have a column of data set numbers (currency), variable in value and
in length, let's say [A1:Ax] and a set extra value [B1]. I need to find
*all* the different combinations of the values in column A that match
[B1].

Here's the problem I'm mainly running into. Teaching it that Two values
equalling B1 is the same as 12 values equalling B1. Anyone have any
ideas before I pull out all my hair?:confused:
 
There has been a little bit of confusion over what I'm trying to do, so
here's a quick example:

A....................B
-----------------------
1....................5
2
1
4
3
1
6
2

**************************************

From this the Spreadsheet would create a pivot table or even just
another column of values listing the cells that would add up to the sum
in B1. In this case:

A1,A2,A3,A6
A1,A2,A8
A1,A3,A5
A1,A3,A6,A8
A1,A4
A1,A5,A6
A2,A3,A8
A2,A5
A2,A6,A8
A3,A4
A4,A6
A5,A8

I've seen something similar done before, but nothing exactly like this.
I'm sure Excel can crunch the numbers, but can it loop itself to find
all of the combinations?
 
Back
Top