In excel pointers should be availible

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prob an easy one: How do i copy a formula EXACTLY as it is 9
Calculate total by row number 4
Count entries in the column translating to minutes. 5
match and display 5
Dependent drop down dynamic range formula, off sheet. 7
Is there a formula that can do this? 3
countifs Function not giving desired result with date criteria 2
Max If function 1

Back
Top