Relative cell reference

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

Guest

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.
 

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 a cell reference from relative to absolute 2
Change relative to absolute references in a block of cells 3
Changing relative references 1
convert relative cell references to absolute cell references via amacro? 1
Copying formulas, relative and absolute cell references 3
Range of cells: Convert relative reference into absolute 5
reference format and column name 1

Top