Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the sorting order... | Excel Worksheet Functions | |||
Sorting by date order | Excel Worksheet Functions | |||
sorting data in order | Excel Worksheet Functions | |||
sorting in order | Excel Worksheet Functions | |||
sorting in order | Excel Worksheet Functions |