clear doubles

[Fabian]

Hi,

I have a large xls sheet with sales figures from 2
customers. As they both partly sell the same products, I
find myself with double rows.

Can someone tell me how I can delete these doubles in 1
time ?

Thanks,
Fabian

 

[Peo Sjoblom]

Use the advanced filter and select unique records only and copy to another
location