sort by the last 2 digits

  • Thread starter Thread starter georgeawwad
  • Start date Start date
G

georgeawwad

I have a long column of 5 digit numbers, i need to sort the column b
the last two digits, can it be done :confused: :confused
 
Hi
use a helper column with the formula
=RIGHT(A1,2)
copied down for all rows and sort with this column
 
Back
Top