Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting
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" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting
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 On Tue, 25 Mar 2008 05:35:06 -0700, Bridget wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
sorting | Excel Worksheet Functions | |||
Sorting | Excel Worksheet Functions | |||
sorting | Excel Discussion (Misc queries) | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) |