HSSC1Copper ContributorMay 29, 2019Sorting on Last 2 Digits of NumberIs there a way to sort data on the last 2 digits of a 8 digit number?
2 RepliesReplies sorted by NewestTwifooSilver ContributorMay 30, 2019HSSC1 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.SortedLastTwoDigits.xlsx10 KBSergeiBaklanDiamond ContributorMay 30, 2019HSSC1 , please check this https://excelribbon.tips.net/T010905_Sorting_by_the_Last_Digits_in_Variable_Length_Data.html
TwifooSilver ContributorMay 30, 2019HSSC1 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.SortedLastTwoDigits.xlsx10 KB
SergeiBaklanDiamond ContributorMay 30, 2019HSSC1 , please check this https://excelribbon.tips.net/T010905_Sorting_by_the_Last_Digits_in_Variable_Length_Data.html
