Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy same cell formula in many rows... | Excel Discussion (Misc queries) | |||
Copy same cell formula in many rows... | Excel Discussion (Misc queries) | |||
copy formula every x rows | Excel Worksheet Functions | |||
COPY FORMULA EVERY TWO ROWS | Excel Discussion (Misc queries) | |||
Copy formula with skipping rows | Excel Worksheet Functions |