同產品單一儲位 聚單格 (11425)

(2007版)D3=IF(COUNTIFS(B$3:B3,B3,C$3:C3,C3)=1,IFERROR(LOOKUP(1,0/(B$2:B2=B3)/(D$2:D2<>""),D$2:D2),"")&IF(COUNTIF(B$3:B3,B3)=1,""," ,")&C3,"")

H3=IFERROR(LOOKUP(1,0/(G3=B$3:B$14)/(D$3:D$14<>""),D$3:D$14),"")