Find Duplicates in Excel

[muddasirmunir]

I have two excel sheet , sheet1 contain about 500 websites addreses and sheet2 contain about 100 ,

Now i want to find and remove any entry in sheet1 that already present in sheet2
or
simple i want to find duplicates in both sheet .

What is the easies way to do that?

[Chad Reasons]

what excel are you using i guess 2007 use this in 2007.click on any cell in the database and after that click data tab on the ribbon and then proceed to click the duplicate icon. U can figure the rest njoy