N
nobbyknownowt
Hmmm
This isprobably simple but I'm getting tired and and confused.
My spreadsheet lists possible cell reference combinations.
firstly a list is calculated in another spreadsheet to show al
possible permutations (ie a1 a2 a3 a4 a5 in 5 seperate cells) i
returns a1,a2,a3,a4,a5 in one cell with another 720 permutations belo
this is copied into my spreadsheet as a base for calculation.
This I then split back to individual cells with =mid(b3,1,2) etc so
now have all my permutations in seperate cells.
I then want to input my actual data into cell a1 a3 a4 a5 and multipl
it buy say g2.
How do I adapt =g2*cell("contents",b3) so that it works? I seem unabl
to be able to make the cell contents "a1" refer to cell a1
am going to do something else now for a while, if anyone has the answe
I will be eternally grateful
cheers
nobb
This isprobably simple but I'm getting tired and and confused.
My spreadsheet lists possible cell reference combinations.
firstly a list is calculated in another spreadsheet to show al
possible permutations (ie a1 a2 a3 a4 a5 in 5 seperate cells) i
returns a1,a2,a3,a4,a5 in one cell with another 720 permutations belo
this is copied into my spreadsheet as a base for calculation.
This I then split back to individual cells with =mid(b3,1,2) etc so
now have all my permutations in seperate cells.
I then want to input my actual data into cell a1 a3 a4 a5 and multipl
it buy say g2.
How do I adapt =g2*cell("contents",b3) so that it works? I seem unabl
to be able to make the cell contents "a1" refer to cell a1
am going to do something else now for a while, if anyone has the answe
I will be eternally grateful
cheers
nobb