A2:A11{=INDEX(G:G,SMALL(IF(MMULT(N($H$2:$M$4>0),ROW(1:6)^0)>=COLUMN($A:$I),ROW($2:$4),99),ROW(A1)))&""
B2:B11{=IF(A2="","",INDEX($1:$1,SMALL(IF(VLOOKUP(A2,G:M,COLUMN(B:G),)>0,COLUMN(H:M)),COUNTIF(A$2:A2,A2))))
C2:D11{=IF($A2="","",IF($B$2=$B2,IF($C$1=C$1,VLOOKUP($A2,$G:$M,2,),""),IF($C$1=C$1,"",SUM(($G$2:$G$4=$A2)*($H$1:$M$1=$B2)*$H$2:$M$4))))
留言
張貼留言