客戶購買 商品與數量 查詢 (13239)

K2:L13{=OFFSET($A$1,SMALL(IF(($C$1:$G$1=$I$2)*($C$2:$G$16>0),ROW($1:$15),99),ROW(A1)),(MATCH($I$2,$1:$1,)-1)^(B$1=$C$1))&""