I3:I11{=IFERROR(SMALL(IF(IF(MATCH(B$3:B$24,B$3:B$24,)=ROW($1:$22),SUMIF(B$3:B$24,B$3:B$24,OFFSET(D$3:D$24,,{0,1,2}))),B$3:B$24),ROW(A1)),"")
J3:J11{=IFERROR(INDEX($2:$2,RIGHT(SMALL(IF(IF(MATCH(B$3:B$24,B$3:B$24,)=ROW($1:$22),SUMIF(B$3:B$24,B$3:B$24,OFFSET(D$3:D$24,,{0,1,2}))),ROW($3:$24)/1%+{4,5,6}),ROW(A1)))),"")
K3:K11=IF(I3="","",SUMPRODUCT((B$3:B$24=I3)*(D$2:F$2=J3)*D$3:F$24))
留言
張貼留言