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

"marello" wrote in
message ...

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


Why not:
011 = 41
111= 253
321=67

Or:
011=51
111=166
321=15

???

Bruno