copy a formula over two rows but increase the row # by 1 only
 

How do you copy a formula from one cell in row "a" to row "c", but only
increase the row reference to "b" automatically?

copy a formula over two rows but increase the row # by 1 only
 

Dave,

Copy it to row 'b' then drag the copy from 'b' to 'c'

HTH,
Bernie
MS Excel MVP


"Dave" wrote in message
...
How do you copy a formula from one cell in row "a" to row "c", but only
increase the row reference to "b" automatically?

copy a formula over two rows but increase the row # by 1 only
 

Rows are numbers, columns are letters.

Hence..............no such thing as "row a" and "row b"

Do you mean column a and b and c or row 1 and 2 and 3

Give an example of what you have in A1 and what you want in A3

Or A1 and C1 if that's the direction you're going.


Gord Dibben MS Excel MVP


On Tue, 11 Aug 2009 08:22:01 -0700, Dave
wrote:

How do you copy a formula from one cell in row "a" to row "c", but only
increase the row reference to "b" automatically?