Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Autofill from column to row
I have a worksheet with data in a column and want the data on another sheet
in a row, sorted in another way. I tried to use autofill to get data from every 25th cell in the column to the row on the other sheet, ['sheet 1'!F2"] in cell B2, ['sheet 1'!F27] in cell C2, ['sheet 1'!F52] in cell D2 and so on. Excel autofill wont understand what I want, is there any other way of solving this? |
#2
|
|||
|
|||
One way
In the destination sheet: Put in B2: =OFFSET('Sheet 1'!$F$2,COLUMNS($A$1:A1)*25-25,) Copy B2 across to D2 B2:D2 will return the desired contents, viz.: in B2: ='Sheet 1'!F2 in C2: ='Sheet 1'!F27 in D2: ='Sheet 1'!F52 etc (at intervals of each 25th cell down) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Magnus Holmberg" <Magnus wrote in message ... I have a worksheet with data in a column and want the data on another sheet in a row, sorted in another way. I tried to use autofill to get data from every 25th cell in the column to the row on the other sheet, ['sheet 1'!F2"] in cell B2, ['sheet 1'!F27] in cell C2, ['sheet 1'!F52] in cell D2 and so on. Excel autofill wont understand what I want, is there any other way of solving this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
Formula for a column | Excel Discussion (Misc queries) | |||
Copying the contents of a column into a chart | Excel Worksheet Functions | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions |