I3 下拉{=INDEX(B:B,MIN(IF((A$2:A$999=H$3)*(COUNTIF(I$2:I2,B$2:B$999)=0),ROW($2:$999),4^8)))&""
(J1:L1 先刪跨欄置中 J1公式三鍵後 J1:L1 跨欄置中 右拉){=IFERROR(OFFSET($C1,MIN(IF(($A2:$A999=$H3)*(COUNTIF($I1:I1,$C2:$C999)=0),ROW($1:$998),4^8)),),"")
J2 右拉=IF(LOOKUP("嫻",$J1:J1)<>"",MID("数量单价金额",(MOD(COLUMN(A1)-1,3)+1)*2-1,2),"")
J3 右拉 下拉=TEXT(SUMIFS(OFFSET($D$2:$D$999,,MOD(COLUMN(C1),3)),$A$2:$A$999,$H$3,$B$2:$B$999,$I3,$C$2:$C$999,LOOKUP("嫻",$J$1:J$1)),"0;;")
留言
張貼留言