F2:I4{=MID("NY",1+(INDEX($C:$C,SMALL(IF($A$2:$A$13=$E2,ROW($2:$13)),COLUMN(A1)))=VLOOKUP(COLUMN(A1),$A$17:$B$20,2,)),1)
J2:J4=COUNTIF(F2:I2,"Y")
F7:F9{=SUM((VLOOKUP(N(IF({1},COUNTIF(OFFSET(A$2,,,ROW($1:$12)),A$2:A$13))),$A$17:$B$20,2,)=$C$2:$C$13)*(A$2:A$13=$E7))
留言
張貼留言