D2{=IFERROR(SMALL(IF(ISNA(MATCH(ROW($1:$5),MMULT(N({2,3,9}=A$1:A$25),{1;1;1})*(INT((ROW($1:$25)-1)/5)+1),)),ROW($1:$5)),ROW(A1)),"")
另解{=TEXT(SMALL(IF(MMULT(COUNTIF(OFFSET(A$1,ROW($1:$5)*5-5,,5),{2,3,9}),{1;1;1})=0,ROW($1:$5),99),ROW(A1)),"[<99]0組;")
另解{=IFERROR(SMALL(IF(MMULT(COUNTIF(OFFSET(A$1,ROW($1:$5)*5-5,,5),{2,3,9}),{1;1;1})=0,ROW($1:$5)),ROW(A1))&"組","")
留言
張貼留言