B Bridget Mar 25, 2008 #1 I have a report that contains names,SSN's, and dates. I need to sort the sheet by the last 2 of the SSN. Can this be done?
I have a report that contains names,SSN's, and dates. I need to sort the sheet by the last 2 of the SSN. Can this be done?
M Mike H Mar 25, 2008 #2 Bridget, Insert a 'helper' column next to the SSN No and extract the 2 rightmost digits to it select all your columns and sort by that To extract last 2 digits use =RIGHT(A1,2) You may have to tell Excel to sort anything that looks like a number as a number Mike
Bridget, Insert a 'helper' column next to the SSN No and extract the 2 rightmost digits to it select all your columns and sort by that To extract last 2 digits use =RIGHT(A1,2) You may have to tell Excel to sort anything that looks like a number as a number Mike
G Gord Dibben Mar 25, 2008 #3 If the SS numbers are in a column by themselves, add a helper column with this formula. =RIGHT(B2,2) when Column B is SSN's Assumes D is helper column and D1 contains a header. Sort on column D Gord Dibben MS Excel MVP
If the SS numbers are in a column by themselves, add a helper column with this formula. =RIGHT(B2,2) when Column B is SSN's Assumes D is helper column and D1 contains a header. Sort on column D Gord Dibben MS Excel MVP
