Delete duplicates based on two collumns

Hi,

I have a big spreadsheet containing costumers purshases for a period. The same customer generally purshased the same product more than once. I need to eliminate all the duplicate lines based with the same value on 2 collumns, the customer (B) and the product (D) in order to keep only one line for each product that the customers purshased.

Thanks for helping...

Simon

Here are two methods. First one uses a formula in Col K, paste and drag down. Then in conjunction with the first macro listed
below, will remove dupes.

The second method (second macro) only requires a command button on Sheet Feuil2 and no formulas.

Please Login or Register  to view this content.

You will be able to view the dupes deletion as the yellow highlighted row will be deleted leaving the beige colored row.

Fantastik! Thanks so much... the idea of merging the cust num. + the product code and delete duplicates was so logic, I probably stayed to late at the office.... I'll keep this trick in mind!

Thanks,

Simon