cell reference formula
Posted by Shelly on May 16, 2001 8:25 AM
I am trying to reference other cells in a different, much simpler spreadsheet. The problem is that the row and columns headings are transposed. So, my formula is =b10 in cell c5. In c6, the formula is =c10, NOT b11, as it would be if you copied the formula down. There are thirty columns I need to do this to. How can I copy the formula so the column changes but not the row?
Posted by Kevin James on May 16, 2001 8:30 AM
Posted by Anon on May 16, 2001 2:54 PM
Also have a look at 17408.html and the replies.
You can use the TRANSPOSE worksheet function (as discussed in the above thread) or alternatively put the following formula in C5 and drag it down :-
=INDIRECT(CHAR((ROW()+61)) & "10")
