Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Diagonal and upwards transposing
Hi
I am trying to do a look up of sorts onto a large table of mortality rates and essentially want to transpose what I have in one table so I get the following in another (example given based on a 4x4 square): A4 A3 A2 A1 B5 B4 B3 B2 C6 C5 C4 C3 D7 D6 D5 D4 etc... Does anyone have any ideas as to the simplest way to go about this? Any assistance much appreciated. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Diagonal and upwards transposing
Source data assumed within A1:D7
In any starting cell, say in F9: =OFFSET($A$1,ROWS($1:1)-COLUMNS($A:A)+3,ROWS($1:1)-1) Copy F9 across/fill down to I12 to populate a 4 x 4 F9:I12 will return the contents of the cells in the desired manner: A4 A3 A2 A1 B5 B4 B3 B2 C6 C5 C4 C3 D7 D6 D5 D4 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "morlo" wrote: Hi I am trying to do a look up of sorts onto a large table of mortality rates and essentially want to transpose what I have in one table so I get the following in another (example given based on a 4x4 square): A4 A3 A2 A1 B5 B4 B3 B2 C6 C5 C4 C3 D7 D6 D5 D4 etc... Does anyone have any ideas as to the simplest way to go about this? Any assistance much appreciated. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Diagonal and upwards transposing
Fantastic - thanks so much!
"Max" wrote: Source data assumed within A1:D7 In any starting cell, say in F9: =OFFSET($A$1,ROWS($1:1)-COLUMNS($A:A)+3,ROWS($1:1)-1) Copy F9 across/fill down to I12 to populate a 4 x 4 F9:I12 will return the contents of the cells in the desired manner: A4 A3 A2 A1 B5 B4 B3 B2 C6 C5 C4 C3 D7 D6 D5 D4 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "morlo" wrote: Hi I am trying to do a look up of sorts onto a large table of mortality rates and essentially want to transpose what I have in one table so I get the following in another (example given based on a 4x4 square): A4 A3 A2 A1 B5 B4 B3 B2 C6 C5 C4 C3 D7 D6 D5 D4 etc... Does anyone have any ideas as to the simplest way to go about this? Any assistance much appreciated. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Diagonal and upwards transposing
welcome
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "morlo" wrote in message ... Fantastic - thanks so much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup : upwards | Excel Discussion (Misc queries) | |||
Searching UPWARDS for a value? | Excel Discussion (Misc queries) | |||
Formula to change number upwards. | Excel Discussion (Misc queries) | |||
Autofill upwards!!!!! | Excel Discussion (Misc queries) | |||
Automatic Numbering Upwards | Excel Discussion (Misc queries) |