单元格重复與不重复数 (9025)

B3{=SUM(N(MMULT(N(TRIM(MID(SUBSTITUTE(A3,",",REPT(" ",99)),ROW($1:$9)*99-98,99))=TRANSPOSE(TRIM(MID(SUBSTITUTE(A3,",",REPT(" ",99)),ROW($1:$9)*99-98,99)))),ROW(1:9)^0)=1))

C3{=SUM(N(MATCH(TRIM(MID(SUBSTITUTE(A3,",",REPT(" ",99)),ROW($1:$9)*99-98,99)),TRIM(MID(SUBSTITUTE(A3,",",REPT(" ",99)),ROW($1:$9)*99-98,99)),)=ROW($1:$9)))-1-B3