Delete duplicate entries

Hi Guys,

I've got a large list of data listed like below. The problem is there are duplicate entries. I need a macro to go through the list and delete any duplicate entries (based on account number).


104777 VWR INTERNATIONAL LTD HUNTER BOULEVARD LUTTERWORTH GBVWRINLUTTE 159 VWR INTERNATIONAL LTD HUNTER
104777 VWR INTERNATIONAL LTD HUNTER BOULEVARD LUTTERWORTH GBVWRINLUTTE 134 VWR INTERNATIONAL LTD HUNTER
104818 R TWINING & CO LIMITED P/O BOX 1612 **ACCOUNTS PAYABLE** ANDOVER GBRTWINANDOV 1201 R TWINING & CO LIMITED
104818 R TWINING & CO LIMITED P/O BOX 1612 **ACCOUNTS PAYABLE** ANDOVER GBRTWINANDOV 2824 R TWINING & CO LIMITED

Any help greatly appreciated

Please Login or Register  to view this content.

Works Perfectly. Thanks very much :D

You are welcome!