Sort by last digit of cell

D

dreambastion

I have a single column of values, invoice numbers. I would like to sor
the column by the last digit of the invoice number. Is this possible
and if so, how
 
F

Frank Kabel

Hi
one way: use a helper column with the formula
=RIGHT(A1,1)
and sort with this column
 
Top