G2:I8{=IFERROR(INDEX($K:$K,RIGHT(LARGE(IF(MMULT(COLUMN(A:T)^0,ISNUMBER(0/(FIND(TRANSPOSE($K$2:$K$8),9&$D$2:$D$21)-1))*($B$2:$B$21=G$1)*$C$2:$C$21),MMULT(COLUMN(A:T)^0,ISNUMBER(0/(FIND(TRANSPOSE($K$2:$K$8),9&$D$2:$D$21)-1))*($B$2:$B$21=G$1)*$C$2:$C$21)/1%+COLUMN($B:$H)),ROW(A1)),2)),"")
M2:O8=IF(G2="","",SUMPRODUCT(($B$2:$B$21=G$1)*ISNUMBER(FIND(G2,$D$2:$D$21))*$C$2:$C$21))
另 解 G2:I8{=INDEX($K:$K,RIGHT(LARGE(TEXT(MMULT(COLUMN(A:T)^0,ISNUMBER(0/(FIND(TRANSPOSE($K$2:$K$8),9&$D$2:$D$21)-1))*($B$2:$B$21=G$1)*$C$2:$C$21)/1%+COLUMN($B:$H),"[<99]99;0")*1,ROW(A1)),2))&""
留言
張貼留言