View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteveT SteveT is offline
external usenet poster
 
Posts: 57
Default Concatenate Unique advanced filter results

Hi out there

I have 2 columns that have been advanced filtered to provide unique records
for shipment destinations / each carrier used for that destination.

B = destination
C = carrier

FRA AA
FRA BA
JFK AA
JFK 5X
SFO AA.... SO ON

I would like to further filter my results so that column C = Ea unique
destination and column D = concatenate result of each carrier used (seperated
by / or , or -)

if anyone can shine some light on how this maybe accomplished, Greate
Appreciated.

Thanks, Steven