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
|