Sorting on Last 2 Digits of Number

Highlighted
Occasional Visitor

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

2 Replies
Highlighted

@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.