Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula to transpose
I have a excel xls that I will create into a very large project. the setup is as follows for my test. a1 = 1 b1 = 2 c1 = 3 d1 = 4 I then want: e1 = a1 so i put =a1 in cell e1, however I want e2 to = b1, and e3 to = c1 and so on. I do not want to manually insert =(cell) in each cell that I want to transpose to. So what kind of formula could I use to complete this task. I would like to drag formula down the e column. Please help. I have no idea on how to write such a formula please construct. Thanks -- oberon.black ------------------------------------------------------------------------ oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732 View this thread: http://www.excelforum.com/showthread...hreadid=479217 |
#2
|
|||
|
|||
formula to transpose
Maybe you started with a bad example.
You can only go down Column E for 4 cells since you'll then run into the contents of E1, where you started from ... right ? ? ? So, guessing that you want to drag a formula *down* a column and reference the contents of a row, let's try this scenario: A1 to AX1 contains the numbers 10 to 500. To copy those values down Column E, starting at E2, enter this formula in E2 and drag down to copy as needed: =INDEX($1:$1,ROW(1:1)) If the values were in A5 to AX5, then starting in E6 you would use: =INDEX($5:$5,ROW(1:1)) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "oberon.black" wrote in message news:oberon.black.1xh22j_1130267135.1302@excelforu m-nospam.com... I have a excel xls that I will create into a very large project. the setup is as follows for my test. a1 = 1 b1 = 2 c1 = 3 d1 = 4 I then want: e1 = a1 so i put =a1 in cell e1, however I want e2 to = b1, and e3 to = c1 and so on. I do not want to manually insert =(cell) in each cell that I want to transpose to. So what kind of formula could I use to complete this task. I would like to drag formula down the e column. Please help. I have no idea on how to write such a formula please construct. Thanks -- oberon.black ------------------------------------------------------------------------ oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732 View this thread: http://www.excelforum.com/showthread...hreadid=479217 |
#3
|
|||
|
|||
formula to transpose
The subject line *does* say "formula", but just to make sure ... you *do*
realize that you can perform a transpose copy, without the need of formulas, don't you? Select A1 to AX1, Right click in the selection and choose "Copy", Right click in E2 and choose "Paste Special", Click on "Transpose", Then <OK. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RagDyer" wrote in message ... Maybe you started with a bad example. You can only go down Column E for 4 cells since you'll then run into the contents of E1, where you started from ... right ? ? ? So, guessing that you want to drag a formula *down* a column and reference the contents of a row, let's try this scenario: A1 to AX1 contains the numbers 10 to 500. To copy those values down Column E, starting at E2, enter this formula in E2 and drag down to copy as needed: =INDEX($1:$1,ROW(1:1)) If the values were in A5 to AX5, then starting in E6 you would use: =INDEX($5:$5,ROW(1:1)) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "oberon.black" wrote in message news:oberon.black.1xh22j_1130267135.1302@excelforu m-nospam.com... I have a excel xls that I will create into a very large project. the setup is as follows for my test. a1 = 1 b1 = 2 c1 = 3 d1 = 4 I then want: e1 = a1 so i put =a1 in cell e1, however I want e2 to = b1, and e3 to = c1 and so on. I do not want to manually insert =(cell) in each cell that I want to transpose to. So what kind of formula could I use to complete this task. I would like to drag formula down the e column. Please help. I have no idea on how to write such a formula please construct. Thanks -- oberon.black ------------------------------------------------------------------------ oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732 View this thread: http://www.excelforum.com/showthread...hreadid=479217 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |