I need help to remove duplicate rows based on the following criteria:
Col A = Location (Destination Company Number)
Col B = LotNo (Lot number of the specific product that I ship to many companies)
Col E = ShipNo (Shipment number)
Each shipment may contain items fromm different lots. Each lot may have many shipments. Col C and D may or may not be unique - they are irrelevant.
I need to produce rows where LotNo, ShipNo & Location are unique.
I am attaching a file. 1st tab shows input raw data, 2nd tab shows needed result. The file contains only one location. The actual file file has all locations.
Thank you.
Bookmarks