Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate Unique advanced filter results
I'm not really sure what you're trying to accomplish but the concatenate
function works like this: =CONCATENATE(A1)," / ",(B1) if you want to concatenate the values in A1 and B1 and have a / separate them. "SteveT" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced filter | Excel Worksheet Functions | |||
Advanced Filter Using Calculaions | Excel Worksheet Functions | |||
Advanced Filter Defaults | Excel Discussion (Misc queries) | |||
Inconsistent Results: Advanced Filter Unique Records Only | Excel Discussion (Misc queries) | |||
Advanced Filter Problems | Excel Discussion (Misc queries) |