B2å ¬å¼=IFERROR(SMALL(IFERROR(IF(1-FREQUENCY(IFERROR(MOD(SMALL(IF(MID(A$2:A$10&IF(LEN(A$2:A$10)>11,"",-RIGHT(A$2:A$10,2)),13,2)-MID(A$2:A$10,10,2)+1>=COLUMN(A:Z),MID(A$2:A$10,10,2)+COLUMN(A:Z)-1+ROW($2:$10)*9^9),ROW($1:$17)),9^9),""),ROW(INDIRECT("1:"&MAX(--RIGHT(A$2:A$10,{1,2}))-1))),ROW($1:$99)),""),ROW(A1)),"")
æ°ç»å ¬å¼ï¼ä¸é®ç»æã