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.

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.

SHJOHN wrote:

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

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

"SHJOHN" wrote:

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.