G2{=COUNT(MATCH(H$2:L$2/1%+COUNTIF(OFFSET(H$2,,,,COLUMN(A:E)),H$2:L$2),A2:E2/1%+COUNTIF(OFFSET(A2,,,,COLUMN(A:E)),A2:E2),))
M2{=INDEX(F:F,SMALL(IF(G$2:G$9=5,ROW($2:$9),99),ROW(A1)))&""
N2{=INDEX(F:F,SMALL(IF(MMULT(ISNUMBER(MATCH(A$2:E$9/1%+COUNTIF(OFFSET(A$2,ROW($1:$8)-1,,,COLUMN(A:E)),A$2:E$9),H$2:L$2/1%+COUNTIF(OFFSET(H$2,,,,COLUMN(A:E)),H$2:L$2),))*1,{1;1;1;1;1})=5,ROW($2:$9),99),ROW(A1)))&""
留言
張貼留言