| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting SS#
Hi,
Is there a way to sort in Excel by the last two digits of SS#? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting SS#
if the SS# are in column A then in a helper column enter:
=RIGHT(A1,2)*1 copy down and sort by the helper column -- Gary's Student gsnu200703 "Perkgolf" wrote: Hi, Is there a way to sort in Excel by the last two digits of SS#? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting SS#
Hi,
Thanks for the suggestion. That gave me the last two digits but I'm unable to sort that column. Bruce "Gary''s Student" wrote: if the SS# are in column A then in a helper column enter: =RIGHT(A1,2)*1 copy down and sort by the helper column -- Gary's Student gsnu200703 "Perkgolf" wrote: Hi, Is there a way to sort in Excel by the last two digits of SS#? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
| Sorting | New Users to Excel | |||
| sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
| Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
| SORTING question | New Users to Excel | |||
Linear Mode
