二條件符合 聚單元格 (10755)

K2 右拉 下拉{=IF(ISERR(INDEX($C$2:$C$16&$G$2:$G$16&"元",SMALL(IF(($A$2:$A$16=$J2)*($G$2:$G$16>0),ROW($1:$15)),COLUMN(A1)))),"",IF(COLUMN(A1)=1,"","，")&INDEX($C$2:$C$16&$G$2:$G$16&"元",SMALL(IF(($A$2:$A$16=$J2)*($G$2:$G$16>0),ROW($1:$15)),COLUMN(A1)))&L2)