I2:N6=TRIM(MID(SUBSTITUTE(INDEX(2:2,COLUMN(B1)/2+1),"vs",REPT(" ",9)),(MOD(COLUMN(B1),2)+1)*9-8,9))
F2:F9{=INDIRECT(TEXT(MIN(IF(COUNTIF(F$1:F1,I$2:N$6),999,ROW($2:$6)/1%+COLUMN(I:N))),"!R0C00"),)&""
G2:G9=IF(F2="","",COUNTIF(I:N,F2))
次數不用輔助欄 G2{=IF(F2="","",COUNT(0/(LEN(B$2:D$6)-LEN(SUBSTITUTE(B$2:D$6,F2,)))))
留言
張貼留言