Customized Sorting Order

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top