E3:G8{=E3:G8{=IFERROR(INDEX($B$3:$B$5/(LEN($A$3:$A$5)-LEN(SUBSTITUTE($A$3:$A$5,"，",))+1),SMALL(IF(FIND($D3,$A$3:$A$5&$D3)<LEN($A$3:$A$5),ROW($1:$3)),COLUMN(A1))),"")
另解{=IFERROR(RIGHT(SMALL(IF(FIND($D3,$A$3:$A$5&$D3)<LEN($A$3:$A$5),$B$3:$B$5/(LEN($A$3:$A$5)-LEN(SUBSTITUTE($A$3:$A$5,"，",))+1)+ROW(1:3)*10^8),COLUMN(A1)),8)*1,"")
留言
張貼留言