| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by last two numbers
On Dec 3, 10:36 pm, Tony wrote:
I would like to sort a group of numberic numbers (1234567) by the last two numbers (i.e. 67) How do I do this? The 1st thing I thought is: add a new column next to your group and use a math function MOD(number,100) or even a text function RIGHT(number,2) there and then sort this new column. Sorry for my English. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort out all numbers without duplication? | Excel Discussion (Misc queries) | |||
| All numbers won't sort | Excel Discussion (Misc queries) | |||
| How to sort text as numbers | Excel Discussion (Misc queries) | |||
| Sort numbers | Excel Discussion (Misc queries) | |||
| sort + & - numbers together | Excel Worksheet Functions | |||
Hybrid Mode
