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


I'm sorry to be causing so much confusion! Let me write my problem out
properly and try and see if that makes things clearer. This spreadsheet
is calculating problematic frequencies in a room. The modes are multiple
of each other, and each wall length causes a mode.

So.....

Mode number x frequency y frequency z
frequency

0 0 0
0
1 22 50
33
2 44 100
66
3 88 200
132

As well as each wall causing a mode, x,y and z can interact with each
other and sum their own frequencies to cause a new one. i need to be
able to calculate all possible combinations of x,yand z.

eg.

011 = 83
111= 110
321 = 221

I have a feeling I'm wanting combinations? But will combinations be
enough to instruct the spreadsheet to instruct the spreadsheet to sum
each possible value of the combination together and list all the
results?

I have a feeling that was clear as mud, I'm sorry it's hard as I don't
quite understand what I want I'm not sure how to ask!

Many thanks for all your help


--
marello
------------------------------------------------------------------------
marello's Profile: http://www.excelforum.com/member.php...o&userid=28566
View this thread: http://www.excelforum.com/showthread...hreadid=482262