Customized Sorting Order
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? |
Customized Sorting Order
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? |
All times are GMT +1. The time now is 02:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com