RE: Duplicate Entries

Dear Alf

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.


I believe that I showed you the Auto Filter or Advanced Filter method for finding duplicate values.

Please find the below ink that I provided the print out for that shows you how you can use a formula and Conditional Formatting to highlight the duplicate values.


http://www.officearticles.com/excel/dealing_with_duplicate_records_in_microsoft_excel.htm

This is another You Tube link that might be more visual:

http://video.google.co.uk/videosearch?hl=en&ei=k53kSaDdNoPU-AaYwrWOCQ&resnum=1&q=MS+Excel+duplicate+values&um=1&ie=UTF-8&ei=lZ3kSaGYPMbR-QaI_s2KCQ&sa=X&oi=video_result_group&resnum=4&ct=title


NB: It is for 2003 version if you want to know where the feature is in 2007 version then please let me know and I should be able to provide you with assistance.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT