Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Flip Cells
Wondering how to take info in a number of rows and flip the rows so that row
100 is now row 1 and row 1 has row 100s information. Not sure if a macro would be better (don't know the code) or is there a simple excel function that does this. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Flip Cells
Simplist way would be
Insert a column to the left of your list. in the first cell of the column put the number 1 In the second cell put the number 2 drag this dow for all 100 rows do a sort on the new list (including the new column) and sort on the first column descending. "Tim" wrote: Wondering how to take info in a number of rows and flip the rows so that row 100 is now row 1 and row 1 has row 100s information. Not sure if a macro would be better (don't know the code) or is there a simple excel function that does this. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Flip Cells
Hi
in a helper cell in B1 enter the formula =OFFSET($A$100,-(ROW()-1),0) and copy this down Afterwards copy this column and use 'Edit - Paste Special - Values' to remove the formulas -- Regards Frank Kabel Frankfurt, Germany "Tim" schrieb im Newsbeitrag ... Wondering how to take info in a number of rows and flip the rows so that row 100 is now row 1 and row 1 has row 100s information. Not sure if a macro would be better (don't know the code) or is there a simple excel function that does this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003: Transpose (flip, swap, rotate) rows and cells. | Excel Worksheet Functions | |||
Can I flip a symbol? | Excel Discussion (Misc queries) | |||
flip table | Excel Discussion (Misc queries) | |||
how do you flip a table around? | Excel Worksheet Functions | |||
hOW DO i FLIP THE X AND Y AXIS | Charts and Charting in Excel |