| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort Order - Non contiguous
Hi, How do I reverse the order in a column. My Column at the momoment is a c d r b t c x and I want to arrange it staring form bottom to top x c t b r d c a and can this be done for any charachter i.e Column of text as above and column of numbers and a combination. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort Order - Non contiguous
Same question asked in public.excel newsgroup
"Yunus" wrote in message m... Hi, How do I reverse the order in a column. My Column at the momoment is a c d r b t c x and I want to arrange it staring form bottom to top x c t b r d c a and can this be done for any charachter i.e Column of text as above and column of numbers and a combination. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort Order - Non contiguous
Entered in B1 assuming data is in column A
=INDEX($A$1:$A$8,8-(ROW(A1)-1)) Drag/copy down to B8 Gord On Sat, 10 Mar 2012 10:04:12 -0000, Yunus wrote: Hi, How do I reverse the order in a column. My Column at the momoment is a c d r b t c x and I want to arrange it staring form bottom to top x c t b r d c a and can this be done for any charachter i.e Column of text as above and column of numbers and a combination. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort Contiguous Columns - Danger | Excel Discussion (Misc queries) | |||
| Retaining Sort order in the Sort Dialog box | Excel Discussion (Misc queries) | |||
| Sort sheet based on particuilar sort order | Excel Worksheet Functions | |||
| Copy and Paste LAST ROW of data: non-contiguous Row, contiguous Column | Excel Programming | |||
| Pls. reply Sort Data and copy to next coulmn when sort order chang | Excel Programming | |||
Linear Mode
