In Excel, how do I sort a column by the LAST digit of the data?

G

Guest

I need to sort a column of data by the LAST digit of the data. We add a
letter to the end of our catalog numbers to denote "new" (ie 012345-N) or
"used" (12345-U), and I'd love to be able to sort by that last digit. Thanks!
 
N

N Harkawat

Insert a column and copy this formula all the way down
=right(a1,1)
Now sort using this column as the first sort criterion and the original
column as the second sort criterion.
 
G

Guest

One way: add a column which has the formula =right(a2,1) (assuming your data
is in column A, starting in row 2). Copy that down. If this is fairly
large, you might then do a copy;paste special values to get rid of the
formulas. Then sort on that column 1st, then the original column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sort a column using the last number in the cell? 2
How do I sort a column in Excel by the last digit in each field 1
Excel Changes My Last Digit to Zero 1
How do I get a column with 12 digit numbers to only show the 1st 1 1
How do I sort by the first digit of a number? 7
How do I copy the last digit of a number from a cell 4
How do I keep a 17 digit number from ending in "0" in excel? 6
sort data automatically by the last column in the table 2

Top