K3 右拉 下拉{=IFERROR(INDEX($F:$F,SMALL(IF((MATCH($A$3:$A$19&$F$3:$F$19,$A$3:$A$19&$F$3:$F$19,)=ROW($1:$17))*($A$3:$A$19=$H3),ROW($3:$19)),COLUMN(A1)))&"/"&SUMIFS($C$3:$C$19,$A$3:$A$19,$H3,$F$3:$F$19,INDEX($F:$F,SMALL(IF((MATCH($A$3:$A$19&$F$3:$F$19,$A$3:$A$19&$F$3:$F$19,)=ROW($1:$17))*($A$3:$A$19=$H3),ROW($3:$19)),COLUMN(A1)))),"")
紅藍色相同
留言
張貼留言