Customized Sorting Order

G

Guest

I have a spreadsheet with customer information including thier social
security numbers listed in one of the columns. I want Excel to sort the
spreadsheet in ascending order by the last two digits of the social security
number only. How can I do this?
 
G

Guest

Use a helper col, then sort both cols by the helper
Assume source in A1 down
Put in B1: =RIGHT(A1,2)+0
Copy down, then sort both cols A and B by col B, ascending
 

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

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
prevent reading or any access to selected cells 2
VBA- Excel Programming:- 0
Excel Linking Multiple cells to One cell for Results 0
How to remove dashes in Social Security number 15
Social Security numbers 5
Query Question 1
Sorting a column in a spreadsheet 2

Top