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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Augustflowers" wrote:
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?