| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse order of numbers in a column
How can I reverse the order of numbers in a column?
i.e. My column contains [1 4 6 3 2] and I want it to contain [2 3 6 4 1]. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reverse order of numbers in a column
in a column next to it, put 1, 2 and fill down. then sort both columns using
this new column, sort descending, delete the helper column. "rcc" wrote: How can I reverse the order of numbers in a column? i.e. My column contains [1 4 6 3 2] and I want it to contain [2 3 6 4 1]. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
