D2{=COUNT(0/(MMULT(N(TRIM(MID(SUBSTITUTE(SUBSTITUTE(B2,"/",REPT(" ",99)),";",REPT(" ",99)),ROW($1:$19)*198-197,99))=TRANSPOSE(TRIM(MID(SUBSTITUTE(SUBSTITUTE(B2,"/",REPT(" ",99)),";",REPT(" ",99)),ROW($1:$19)*198-197,99)))),ROW(1:19)^0)>1)/(TRIM(MID(SUBSTITUTE(SUBSTITUTE(B2,"/",REPT(" ",99)),";",REPT(" ",99)),ROW($1:$19)*198-197,99))<>""))
留言
張貼留言