May 29 2019 03:07 PM
Is there a way to sort data on the last 2 digits of a 8 digit number?
May 29 2019 05:05 PM
May 29 2019 10:24 PM
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.