Relative cell reference

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

Guest

Is it a way to make a formula containing a relative cell reference that e.g.
change one step when copying cell 2 steps.
 
the indirect function may do what you want
I am not sure what you want to do
if effectively you have
=b1 in A1
and you want to have
=b3 is A2
then try
=indirect("B"&(row()*2-1))
in A1
and copy down

there are other methods which may work better depending on the details of
what you are doing.
 
You must log in or register to reply here.

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

advanced relative cell reference 1
Change relative to absolute references in a block of cells 3
Change a cell reference from relative to absolute 2
convert relative cell references to absolute cell references via amacro? 1
Changing relative references 1
reference format and column name 1
Copying formulas, relative and absolute cell references 3
Range of cells: Convert relative reference into absolute 5

Back
Top