E2:G2 下拉{=IFERROR(OFFSET($A$1,RIGHT(SMALL(IF((COUNTIFS($E$1:$E1,$A$2:$A$99,$G$1:$G1,$C$2:$C$99)=0)*($A$2:$A$99>0),MATCH($A$2:$A$99&"",$A$2:$A$99&"",)/1%%+ROW($1:$98)),1),2),COLUMN(A1)-1),"")
改F2 下拉=IF(E2="","",SUMPRODUCT((A$2:A$99=E2)*(C$2:C$99=G2)*(0&LEFT(B$2:B$99,LEN(B$2:B$99)-(B$2:B$99<>""))))&RIGHT(VLOOKUP(E2,A:B,2,)))
留言
張貼留言