| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a relative column formula
I want to copy a formula that has a relative column and an absolute row A$3
but when I try to copy it down the column doesn't change it copies the same A$3 and I want B$3 C$3 etc.. Can someone help me? Thanks!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create a relative column formula
Sounds like your problem is revealed in the phrase "whencopy it down". If you are staying in the same column, Excel has no reason to change the column part of your formula. Instead, copy the formula to the right - which will cause Excel to generate cell formulas like you want. Then copy the formulas and use Paste Special Transpose to get them into a column... -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113061 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create a relative column formula
When you copy down, XL will only change the relative row (if possible). If
you want to copy down, but want to change columns, perhaps this will work: =INDIRECT("R3C"&ROW(A1),FALSE) This currently refers to A3. Copying down will change the row in formula to A2, causing overall formula to reference B3. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Luzma" wrote: I want to copy a formula that has a relative column and an absolute row A$3 but when I try to copy it down the column doesn't change it copies the same A$3 and I want B$3 C$3 etc.. Can someone help me? Thanks!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create a relative column formula
Thanks so much for your help!!
"jamescox" wrote: Sounds like your problem is revealed in the phrase "whencopy it down". If you are staying in the same column, Excel has no reason to change the column part of your formula. Instead, copy the formula to the right - which will cause Excel to generate cell formulas like you want. Then copy the formulas and use Paste Special Transpose to get them into a column... -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113061 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create a relative column formula
That is exactly how it should be. Since you are copying down a column, the
reference to A will not change Workaround: drag to the left. So lets say we now have =A$3, =B$3, =C$3 ... starting in B10 Copy all these formulas except the first, move to B11 and use Paste Special with Transpose specified Now you have what you want but will need to delete C10, D10..... best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Luzma" wrote in message ... I want to copy a formula that has a relative column and an absolute row A$3 but when I try to copy it down the column doesn't change it copies the same A$3 and I want B$3 C$3 etc.. Can someone help me? Thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I make a row absolute, but column relative, the column stays. | Excel Discussion (Misc queries) | |||
| How do I create relative hyperliks inside Excellworkbook ? Sweden | Excel Discussion (Misc queries) | |||
| How do I create a formula for an entire column | New Users to Excel | |||
| How do I create a Histogram for relative frequency distributions? | Excel Discussion (Misc queries) | |||
| how can I create a histogram with relative frequency? | Excel Discussion (Misc queries) | |||
Linear Mode
