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
