How can I sort a column by the last positions of each cell

[Guest]

I need to sort a column of cells that contain 11 numeric characters each by
the last 4 positions in each cell and produce a list. There will be multiple
matches for each cell.

 

[Dave Peterson]

Use another column filled with formulas like:

=right(a1,4)

Then sort by that column.

I'm not sure what kind of list you need.

 

[Guest]

You can insert a 'helper' column next to the column with a formula that
strips out the desired characters. A formula such as "=RIGHT(A1,4)" (without
the quotes) will provide the last 4 characters for cell A1. Then you can copy
this formula down for each row in the column you want to sort, and then sort
by this 'helper' column.

HTH,

TK