Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I flip the order of a column? (it is sequintial, so not sor
I want to invert my text so that the bottom is the top and the top is the
bottom. It is not sequential so normal sort is not working. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I flip the order of a column? (it is sequintial, so not sor
I like to use a helper column.
Put 1 in the top cell. put 2 in the second cell. Select both those cells and drag down the column. You'll end up with line numbers for each row. Then select all the range (including that column) and sort that column in descending order. You can delete that column when you're done--or use it to reverse the sort, then delete it. justjessica wrote: I want to invert my text so that the bottom is the top and the top is the bottom. It is not sequential so normal sort is not working. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I flip the order of a column? (it is sequintial, so not sor
One more method.
Assume your data is in A1:A30 In B1 enter =INDEX($A$1:$A$30,30-(ROW(A1)-1)) Copy down to B30 Gord Dibben MS Excel MVP On Sun, 17 Dec 2006 06:31:00 -0800, justjessica wrote: I want to invert my text so that the bottom is the top and the top is the bottom. It is not sequential so normal sort is not working. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
I typed a column in reverse order, how do I flip it (upside down). | Charts and Charting in Excel |