| 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
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 | |||
Hybrid Mode
