Comparing Data
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. |
All times are GMT +1. The time now is 01:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com