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

[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?

 

[Bernie Deitrick]

Dave,

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

HTH,
Bernie
MS Excel MVP

 

[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