View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] nieferge@gmail.com is offline
external usenet poster
 
Posts: 1
Send a message via Skype™ to nieferge@gmail.com
Default 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.