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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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
 
Back
Top