排列次序 依指定前面數字 (10820)

C2{=RIGHT(SMALL(IFERROR(MATCH(LEFT(B$2:B$16)*1,E:E,),9)/1%%+IF(ISNA(MATCH(LEFT(B$2:B$16)*1,E:E,)),,RIGHT(B$2:B$16))/1%+B$2:B$16,ROW(A1)),2)*1