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.
|