- =INDEX(RIGHT(SMALL(IF(COUNTIF($L9,TEXT(SMALL(--MID(SMALL({0,2,4,6,8}*10+{1;3;5;7;9}*101,ROW($1:$25)),{1,2},2),COLUMN($A:$AX)),"\*0\*0\*")),ROW(1:10)/1%+SMALL(--MID(SMALL({0,2,4,6,8}*10+{1;3;5;7;9}*101,ROW($1:$25)),{1,2},2),COLUMN($A:$AX))),4-{3,2,1,0}),2),,SMALL(IF(COUNTIF($M$2:$M$6,RIGHT(SMALL(IF(COUNTIF($L9,TEXT(SMALL(--MID(SMALL({0,2,4,6,8}*10+{1;3;5;7;9}*101,ROW($1:$25)),{1,2},2),COLUMN($A:$AX)),"\*0\*0\*")),ROW(1:10)/1%+SMALL(--MID(SMALL({0,2,4,6,8}*10+{1;3;5;7;9}*101,ROW($1:$25)),{1,2},2),COLUMN($A:$AX))),4-{3,2,1,0}),2))=0,COLUMN($A:$D)),COLUMN(A1)))
复制代码 |