If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|