F2{=IFERROR(INDEX(A:A,SMALL(IF(LEN(B$2:B$5)-LEN(SUBSTITUTE(B$2:B$5,"、",))+1>=COLUMN(A:I),ROW($2:$5)),ROW(A1))),"")
G2=IF(F2="","",TRIM(MID(SUBSTITUTE(VLOOKUP(F2,A:B,2,),"、",REPT(" ",99)),COUNTIF(F$2:F2,F2)*99-98,99)))
H2=IF(F2="","",IF(COUNTIF(F:F,F2)=COUNTIF(F$2:F2,F2),VLOOKUP(F2,A:C,3,)-SUMIF(F$1:F1,F2,H$1:H1),RANDBETWEEN(1,VLOOKUP(F2,A:C,3,)/COUNTIF(F:F,F2))))
D2=SUMIF(F:F,A2,H:H)
留言
張貼留言