判斷後 提取所需數據 (14873)

G3:G7{=INDEX(A:A,MIN(IF(COUNTIF(G$2:G2,A$3:A$21)=0,ROW($3:$21),99)))&""

H3:K7{=IF($G3="","",INDEX(B:B,ABS(MIN(IF(($A$3:$A$21=$G3)*(B$3:B$21>0),ROW($3:$21)*-1^(COLUMN(A1)>2))))))



留言