H2:H21{=(OR(OFFSET(C$1:G$1,LOOKUP(1,0/(B$2:B2="五"),ROW($1:1)),)=37)*OR(MMULT(N(RIGHT(OFFSET(C$1:G$1,LOOKUP(1,0/(B$2:B2="五"),ROW($1:1))+1,,4))-7=0),{1;1;1;1;1})>0)*OR(RIGHT(C2:G2)-7=0))*(OR(COUNTIF(OFFSET(C$1:G$1,LOOKUP(1,0/(B$2:B2="五"),ROW($1:1)),,ROW(A2)-LOOKUP(1,0/(B$2:B2="五"),ROW($1:1))),C2:G2)*(RIGHT(C2:G2)-7=0)=1))
K2:Q10{=INDEX(A:A,SMALL(IF($H$2:$H$21,ROW($2:$21),99),ROW(A1)))&""
留言
張貼留言