MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sorting ID #'s by last digit


Posted by Duane on August 02, 2001 9:06 AM

Is it possible to find and sort a list of numbers by their last digit?
Say I've got a list of 1000 numbers and I want to find all the numbers that end in 3. Thanks.


Posted by Barrie Davidson on August 02, 2001 9:13 AM

Use a formula beside your numbers that extracts the last digit and then sort on that. The syntax is =RIGHT(A1,1), where your number is in cell A1.

Barrie