Search for duplicate record in 2 excel spread sheet

Hi guys, how can i search for duplicate records in 2 excel spread sheet

What can i do to eliminate the duplicates? or is there any functions which can help me to identify the duplicates records?

Thanks

Sheet 1 Sheet 2
Material Material
SC10609 SC10609
SC08002 SC10623
SC08001 SC03006
SC08003 SC01016
SC08011 SC10610
SC09001 SC02021
SC08004 SC11290
SC08005 SC10334
SC10623 SC11379
SC03008 SC10516
SC03007 SC07011
SC10417 SC11287
SC10450 SC11274
SC10433 SC11385
SC10452 SC11131
SC10762 SC02026
SC10543 SC02030
SC10538 SC11295
SC03006 SC10512
SC10359 SC01002
SC10469 SC11377
SC10141 SC08026
SC10142 SC11071
SC01016 SC10626
SC10241 SC03009
SC10610 SC03011
SC10355 SC10419
SC10586 SC10475
SC02021 SC10477
SC10358 SC10370
SC10244 SC11301
SC11282 SC10184
SC10269 SC10841
SC11077 SC11283
SC10597 SC10263
SC10596 SC05000
SC10340 SC10188
SC10317 SC11011
SC10600 SC10755
SC10279 SC11009
SC02007 SC10909
SC10601 SC11347
SC10115 SC10619
SN10004 SC11349
SN10339 SC11350
SN10406 SC11351
SN10408 SC11352
SN10409 SC11353
SN10411 SN10002
SN10415 SN10005
SN10534 SN10893
SN10783 SN11200
SN10839 SN11622
SN10845 SN11635
SN10849 SN11669
SN10850 SN11684
SN11180 SN11804
SN11196 SN11850
SN11200 SN11853
SN11361 SN11857
SN11612 SN11858
SN11665 SN11859
SN11688 SN11863
SN11797 SN11864
SN11801 SN11878
SN11853 SN11881
SN11857 SN11918
SN11858 SN11919
SN11859
SN11860
SN11861
SN11865
SN11880
SN11883
SN11913
SN11918

Originally Posted by Jimi

Hi guys, how can i search for duplicate records in 2 excel spread sheet

What can i do to eliminate the duplicates? or is there any functions which can help me to identify the duplicates records?

Thanks

Sheet 1 Sheet 2
Material Material
SC10609 SC10609
SC08002 SC10623
SC08001 SC03006
SC08003 SC01016
SC08011 SC10610
SC09001 SC02021
SC08004 SC11290
SC08005 SC10334
SC10623 SC11379
SC03008 SC10516
SC03007 SC07011
SC10417 SC11287
SC10450 SC11274
SC10433 SC11385
SC10452 SC11131
SC10762 SC02026
SC10543 SC02030
SC10538 SC11295
SC03006 SC10512
SC10359 SC01002
SC10469 SC11377
SC10141 SC08026
SC10142 SC11071
SC01016 SC10626
SC10241 SC03009
SC10610 SC03011
SC10355 SC10419
SC10586 SC10475
SC02021 SC10477
SC10358 SC10370
SC10244 SC11301
SC11282 SC10184
SC10269 SC10841
SC11077 SC11283
SC10597 SC10263
SC10596 SC05000
SC10340 SC10188
SC10317 SC11011
SC10600 SC10755
SC10279 SC11009
SC02007 SC10909
SC10601 SC11347
SC10115 SC10619
SN10004 SC11349
SN10339 SC11350
SN10406 SC11351
SN10408 SC11352
SN10409 SC11353
SN10411 SN10002
SN10415 SN10005
SN10534 SN10893
SN10783 SN11200
SN10839 SN11622
SN10845 SN11635
SN10849 SN11669
SN10850 SN11684
SN11180 SN11804
SN11196 SN11850
SN11200 SN11853
SN11361 SN11857
SN11612 SN11858
SN11665 SN11859
SN11688 SN11863
SN11797 SN11864
SN11801 SN11878
SN11853 SN11881
SN11857 SN11918
SN11858 SN11919
SN11859
SN11860
SN11861
SN11865
SN11880
SN11883
SN11913
SN11918

In Sheet 2
B2: =IF(COUNTIF(Sheet1!$A$2:$A$77,A2)>0,"Dup","Not dup")

Hey chap, thanks for reply. Get it done.. Fast and quick...