Sorting on Last 2 Digits of Number

[HSSC1]

Is there a way to sort data on the last 2 digits of a 8 digit number?

[#2]

@HSSC1 , please check this https://excelribbon.tips.net/T010905_Sorting_by_the_Last_Digits_in_Variable_Length_Data.html

[#3]

@HSSC1 

If your 8-digit numbers are in A2:A10, the formula in B2, copied down rows, to sort the numbers based on their last 2 digits is: 

=LOOKUP(PI(),
1/(--RIGHT(A$2:A$10,2)=AGGREGATE(15,4,--RIGHT(A$2:A$10,2),ROW()-1)),
A$2:A$10)

See the sample in the attached file.