I used this to find duplicates, this will probably help you.

http://office.microsoft.com/en-us/as...366161033.aspx

if you need any help let me know

" wrote:

I have a list that contains approx 4000 rows of info - school code,
school name, address and email. Some school codes are duplicated as a
result of a workbook merge. I need to search through the information,
find the duplicated rows and delete the row that DOES NOT contain an
email address. How do I do this within Excel, or is this easier in
Access?