Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to copy down formulars into same column by a row left to righ
Try to copy down formulars into a column from a row from left to right
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to copy down formulars into same column by a row left to righ
I think you need to explain more, give an example of a formula
and what you mean by copying down from left to right? My guess is that you want to copy a formula to the right in the same row but somehow use the cells going down in a column =INDEX($A:$A,COLUMNS($A:A)) will return what's in A1, A2, A3 and so on when copied to the right Post back if that's not the case -- Regards, Peo Sjoblom "Holly" wrote in message ... Try to copy down formulars into a column from a row from left to right |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to copy down formulars into same column by a row left to r
I try to copy all headings from one row in a tab, to a column in another tab,
I know how to do transpose paste from copy & paste function, but I need to set up a formula in the column, so I could drag down the formula to get the all headings if there's any changes in the headings. Thanks, Holly "Peo Sjoblom" wrote: I think you need to explain more, give an example of a formula and what you mean by copying down from left to right? My guess is that you want to copy a formula to the right in the same row but somehow use the cells going down in a column =INDEX($A:$A,COLUMNS($A:A)) will return what's in A1, A2, A3 and so on when copied to the right Post back if that's not the case -- Regards, Peo Sjoblom "Holly" wrote in message ... Try to copy down formulars into a column from a row from left to right |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to copy down formulars into same column by a row left to r
=INDEX($B$1:$P$1,,ROWS($A$1:A1))
copied down will return what's in B1, C1, D1 and so on until P1, adapt to fit accordingly -- Regards, Peo Sjoblom "Holly" wrote in message ... I try to copy all headings from one row in a tab, to a column in another tab, I know how to do transpose paste from copy & paste function, but I need to set up a formula in the column, so I could drag down the formula to get the all headings if there's any changes in the headings. Thanks, Holly "Peo Sjoblom" wrote: I think you need to explain more, give an example of a formula and what you mean by copying down from left to right? My guess is that you want to copy a formula to the right in the same row but somehow use the cells going down in a column =INDEX($A:$A,COLUMNS($A:A)) will return what's in A1, A2, A3 and so on when copied to the right Post back if that's not the case -- Regards, Peo Sjoblom "Holly" wrote in message ... Try to copy down formulars into a column from a row from left to right |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to copy down formulars into same column by a row left to r
if I use "INDEX($B$1:$P$1,,ROWS($A$1:A1))", I get #REF!, but if I change to
"INDEX($B$1:$P$1,,COLUMNS($A$1:A1)), I get the same results from B1 in all cells when I drag down the formula. "Peo Sjoblom" wrote: =INDEX($B$1:$P$1,,ROWS($A$1:A1)) copied down will return what's in B1, C1, D1 and so on until P1, adapt to fit accordingly -- Regards, Peo Sjoblom "Holly" wrote in message ... I try to copy all headings from one row in a tab, to a column in another tab, I know how to do transpose paste from copy & paste function, but I need to set up a formula in the column, so I could drag down the formula to get the all headings if there's any changes in the headings. Thanks, Holly "Peo Sjoblom" wrote: I think you need to explain more, give an example of a formula and what you mean by copying down from left to right? My guess is that you want to copy a formula to the right in the same row but somehow use the cells going down in a column =INDEX($A:$A,COLUMNS($A:A)) will return what's in A1, A2, A3 and so on when copied to the right Post back if that's not the case -- Regards, Peo Sjoblom "Holly" wrote in message ... Try to copy down formulars into a column from a row from left to right |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to copy down formulars into same column by a row left to r
The formula I gave will work, copied down it will give you the result
However you need to adapt it to your situation, does you headers start in the Do this test put 1, 2 and 23 in B1, C1 and D1 then put =INDEX($B$1:$P$1,,ROWS($A$1:A1)) in A1 and copy down to A3, now in A1 you should get 1, in A2 2 and in A3 3 Now adapt it to your spreadsheet -- Regards, Peo Sjoblom "Holly" wrote in message ... if I use "INDEX($B$1:$P$1,,ROWS($A$1:A1))", I get #REF!, but if I change to "INDEX($B$1:$P$1,,COLUMNS($A$1:A1)), I get the same results from B1 in all cells when I drag down the formula. "Peo Sjoblom" wrote: =INDEX($B$1:$P$1,,ROWS($A$1:A1)) copied down will return what's in B1, C1, D1 and so on until P1, adapt to fit accordingly -- Regards, Peo Sjoblom "Holly" wrote in message ... I try to copy all headings from one row in a tab, to a column in another tab, I know how to do transpose paste from copy & paste function, but I need to set up a formula in the column, so I could drag down the formula to get the all headings if there's any changes in the headings. Thanks, Holly "Peo Sjoblom" wrote: I think you need to explain more, give an example of a formula and what you mean by copying down from left to right? My guess is that you want to copy a formula to the right in the same row but somehow use the cells going down in a column =INDEX($A:$A,COLUMNS($A:A)) will return what's in A1, A2, A3 and so on when copied to the right Post back if that's not the case -- Regards, Peo Sjoblom "Holly" wrote in message ... Try to copy down formulars into a column from a row from left to right |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column labels run right to left, not left to right | Excel Discussion (Misc queries) | |||
formulars | Excel Worksheet Functions | |||
need help with formulars | Excel Discussion (Misc queries) | |||
Right column doesn't change when sorting left column. | Excel Discussion (Misc queries) | |||
strange column to the left of my row numbers column | Excel Discussion (Misc queries) |