Changing absolute references

[bartmacl]

Hello, I am using Excell 2002. I am familiar with the $A$1 notation to
produce absolute references when copying cells. However, I want to be able
to copy a reference but have it increment in a way that I presently can't
figure out how to do.

For example, in the following cells, I have manually entered the following
references
B3 = 1/C2
B4 = 1/D2
B5 = 1/E2

when I copy B5 to B6, the reference becomes 1/E3. I want the reference for
B6 to be 1/F2.

Thanks

bmac

 

[bartmacl]

Thanks very much!

bmac

bmac,

In cell B3 put this formula and copy down.

=1/OFFSET($B$2,0,ROW(C3)-2)

PC

 

[Paul Corrado]

bmac,

In cell B3 put this formula and copy down.

=1/OFFSET($B$2,0,ROW(C3)-2)

PC