J2:N3=TRIM(MID(SUBSTITUTE(LEFT($B2:$B3,FIND("-",$B2:$B3)-1),"、",REPT(" ",99)),COLUMN(A1)*99-98,99))
F2{=INDIRECT(TEXT(MIN(IF((COUNTIF(F$1:F1,J$2:N$3)=0)*(J$2:N$3<>""),{2;3}/1%+COLUMN(J:N),9999)),"!R0C00"),)&""
G2=IF(F2="","",SUMPRODUCT(C$2:C$3/(LEN(B$2:B$3)-LEN(SUBSTITUTE(B$2:B$3,"、",))+1)*(LEN(B$2:B$3)-LEN(SUBSTITUTE(B$2:B$3,F2,)))/LEN(F2)))
留言
張貼留言