Find duplicate records in 2 columns

[Rajkumar]

Hi,

I need a formula to find out the duplicate records for the following eg
& delete the duplicate records..for eg:

Column B Columnn C
---------------------------------------------
1 4194611
1 4700001
1 3542631
1 4700001(this row tobe deleted)
2 4194611
2 4700001
2 2525483
4 3542631
4 4194611
4 3542631(this row tobe deleted)
5 3542631
5 4194611

Column B is serial no's & column C is part nos.For the same serial no
there should not be duplicating Part nos.

note : my file contains 3500 rows of data.

Pls help out me a way to solve this.
Rajkumar

 

[Peo Sjoblom]

Select the range, do data>filter>advanced filter, select copy to another
location and unique records only