Hi, Is there a way to sort in Excel by the last two digits of SS#? Thanks
G Gary''s Student Feb 2, 2007 #2 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
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
P Perkgolf Feb 2, 2007 #3 Hi, Thanks for the suggestion. That gave me the last two digits but I'm unable to sort that column. Bruce
Hi, Thanks for the suggestion. That gave me the last two digits but I'm unable to sort that column. Bruce
