In excel pointers should be availible

M

Mike@Delphi

many times you could save repeating formulas if you could change the row you
want to reference by pointing to a value in another cell to deisnate the row
you wish to refernce in a formula.

example if your formula cotained the A(B2) and B2 contained a value of 5 the
formula would be refernce A5. If you then change the value of B2 to say 10
the formula would now refence A10.
 
F

Fredrik Wahlgren

Mike@Delphi said:
many times you could save repeating formulas if you could change the row you
want to reference by pointing to a value in another cell to deisnate the row
you wish to refernce in a formula.

example if your formula cotained the A(B2) and B2 contained a value of 5 the
formula would be refernce A5. If you then change the value of B2 to say 10
the formula would now refence A10.
Click to expand...

Excel's INDIRECT function comes close
http://www.cpearson.com/excel/indirect.htm

/Fredrik
 
Top