代號取資料 同代號廠商數不固定 (14734)

I2:L10{=IFERROR(INDEX(B:B,RIGHT(SMALL(IF($A$2:$A$999=$G$2,MATCH($A$2:$A$999&$B$2:$B$999,$A$2:$A$999&$B$2:$B$999,)/1%+ROW($2:$999)),ROW(A1)),2)),"")

A2:E21 格式化=$G$2=$A2