ExcelBanter - sorting SS#

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sorting SS# (https://www.excelbanter.com/excel-discussion-misc-queries/128929-sorting-ss.html)

Perkgolf

sorting SS#

Hi,
Is there a way to sort in Excel by the last two digits of SS#?

Thanks

Gary''s Student

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

Perkgolf

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

All times are GMT +1. The time now is 03:27 PM.