Cell reference in a formula

[Guest]

When I copy a basic formula down a COLUMN that refernces another cell, the formula will automatically replace the cell referenced for the one right beneath it (basic excel 101). I don't know of a way to copy a cell to the cell beneath it while referencing the next one in the ROW. Hopefully this makes sense to someone who can help. Thanks.

 

[Barrie Davidson]

On 2002-03-04 18:31, Anonymous wrote:
When I copy a basic formula down a COLUMN that refernces another cell, the formula will automatically replace the cell referenced for the one right beneath it (basic excel 101). I don't know of a way to copy a cell to the cell beneath it while referencing the next one in the ROW. Hopefully this makes sense to someone who can help. Thanks.

Can you give a quick example of what you mean?


_________________

Barrie Davidson
My Excel Web Page
This message was edited by Barrie Davidson on 2002-03-04 18:34
This message was edited by Barrie Davidson on 2002-03-04 18:34

 

[Q45]

Sure. Cell A1 is "=B12". If I copy A1 to B1, I will get "=B13". I am wanting to copy A1 to B1 but get a "=C12" result. I hope this helps.

 

[Barrie Davidson]

On 2002-03-04 18:40, Q45 wrote:
Sure. Cell A1 is "=B12". If I copy A1 to B1, I will get "=B13". I am wanting to copy A1 to B1 but get a "=C12" result. I hope this helps.

If I copy cell A1 (containing "=B12") to B1, I get the formula "=C12". I don't understand your problem. Can you clarify it for me?

 

[Q45]

No you don't. Try it.

 

[Barrie Davidson]

On 2002-03-04 19:07, Q45 wrote:
No you don't. Try it.

I did. If I have "=B12" in A1 and copy to B1, B1's formula is "=C12".

What am I missing here??

 

[Q45]

Sorry. You're right. Typo. I meant "Cell A1 is "=B12". If I copy A1 to A2, I will get "=B13". I am wanting to copy A1 to A2 but get a "=C12" result." Again, sorry.

 

[Barrie Davidson]

On 2002-03-04 19:11, Q45 wrote:
Sorry. You're right. Typo. I meant "Cell A1 is "=B12". If I copy A1 to A2, I will get "=B13". I am wanting to copy A1 to A2 but get a "=C12" result." Again, sorry.

Phew, good thing. I thought I was losing it for a second.
Try this formula in A1 and copy to A2:

=INDIRECT("R12C"&ROW()+1,0)

Regards,

 

[Q45]

Sorry for the confusion. That worked perfect. Thanks.