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

D

Dave

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

Bernie Deitrick

Dave,

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

HTH,
Bernie
MS Excel MVP
 
G

Gord Dibben

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
 
Top