Assume SSN is in column D. Put this formula in a helper column:

=RIGHT(D2,2)*1

and copy down. Then include this helper column in your sort area and
sort by the helper column.

Multiplying by 1 converts the extracted digits to real numbers, so
that your sort makes sense.

Hope this helps.

Pete


On Mar 25, 7:07*pm, Bridget wrote:
I have 3 colums of information. One of the colums contains SSN's. I need to
sort by the last 2 digits of the SSN and I can't seem to fiqure out how to do
this. Any help would be greatly appreciated.