二項不重複 取出多列 (14395)

M2:U6{=IFERROR(OFFSET($A$1,RIGHT(SMALL(IF(COUNTIFS($P$1:$P1,$D$2:$D$9,$Q$1:$Q1,$E$2:$E$9)=0,$A$2:$A$9/1%+ROW($1:$8)),1),2),MATCH(M$1,$1:$1,)-1),"")

R2:U6=IF($M2="","",SUMIFS(F:F,$A:$A,$M2,$D:$D,$P2,$E:$E,$Q2))



留言