I have a worksheet that must be updated every day. I get new information
everyday that must be imported into Excel, formatted, and then compied over
to the existing worksheet.

The worksheet looks like this.

ColumnA Column B
Company Container #
Hunter APHU1234567/APL
Hunter APLU1234567/HYD
Casa TEXU1234567/APL
Casa APHU1234567/APL

Some of these values are duplicates. I need a function that compares B2 to
all of column B. If it finds a duplicate I need it to compare the entry in
column A corresponding to the duplicates in column B. If they are the same
then one duplicate is kept and the other is deleted. If they are different
(ie one Hunter and one Casa) I need the Hunter to be replaced with Hun/Casa
and the other to be deleted.

Any help is appreciated.