K2{=COUNT(0/IFERROR(MMULT(N(TEXT(A$2:A$14,{"EMD","EM","E"})-INDEX(TEXT(H$2,{"EMD","EM","E"}),ROW(A1))=0),{1;1;1}),1)/(MATCH(B$2:B$14,B:B,)=ROW($2:$14)))
L2{=SUM((IFERROR(MMULT(N(TEXT(A$2:A$14,{"EMD","EM","E"})-INDEX(TEXT(H$2,{"EMD","EM","E"}),ROW(A1))=0),{1;1;1}),1)>0)*D$2:D$14)
留言
張貼留言