Combinations

[GTS]

Hello people! What i have is something like this:

Column A Column B Column C
1 b1 c1
2 b2 c2
3 b3 c3
4 b4 c4
5 b5 c5


where bi, ci (i=1...5) are numbers.

Now, what i'd like to do:

I'd like to have two new columns where

Column D Column E
i-j ai*bj

for all i,j

The first rows would be like

Column C Column D
1-1 a1*b1
1-2 a1*b2
2-1 a2*b1
3-1 a3*b1
etc etc

for all unique combinations of ai and bj.

Any clue how?

Thanks in advance

 

[Guest]

I think you can get what you need using the INDIRECT function. If you have 1 in cell D1, and 2 in cell E1 then the formula

=INDIRECT("B"&D1)*INDIRECT("C"&E1

will evaluate as =B1*C2

Good Luck
Mark Graesse
(e-mail address removed)

----- GTS wrote: ----


Hello people! What i have is something like this

Column A Column B Column
1 b1 c
2 b2 c
3 b3 c
4 b4 c
5 b5 c


where bi, ci (i=1...5) are numbers

Now, what i'd like to do

I'd like to have two new columns wher

Column D Column
i-j ai*b

for all i,

The first rows would be lik

Column C Column
1-1 a1*b
1-2 a1*b
2-1 a2*b
3-1 a3*b
etc et

for all unique combinations of ai and bj

Any clue how

Thanks in advance