View Single Post
  #6   Report Post  
Bruno Campanini
 
Posts: n/a
Default Getting Excel to Calculate All Combinations of a Set of Data?

"marello" wrote in
message ...

I don't know which I need!


???

Say if I have values 1-5 I want excel to be able to calculate all
combinations of them and then in seperate cell for each combination add
them together to give the value for each combination.


These are five values:
1 2 3 4 5

and these all the possible Combinations:
C(5,1) = 5 1 2 3 4 5

C(5,2) = 10 12 13 14 15
23 24 25
24 35
45

C(5,3) = 10 123 124 125 134 135 145
234 235 245
345

C(5,4) = 5 1234 1235 1245 1345 2345

C(5,5) = 1 12345

Now what do you want to do?

Bruno