连续三行有指定數 (11608)

Q2{=AND(MMULT(N(A2:G4=TRANSPOSE(I$1:K$1)),ROW(1:7)^0)>0)*1

I2:O9{=INDEX(A:A,SMALL(IF(FREQUENCY(IF($Q$2:$Q$16,ROW($2:$16)+{0,1,2}),ROW($2:$16)),ROW($2:$17),99),ROW(A1)))&""


留言