How to find duplicates in Excel

February 6th, 2009

ExcelWill, one of CallFire’s seasoned support reps, ran into a situation where he needed to scan for dupes real quick in an exported CSV.

He found, If you combine these two steps you can do a sort and find it right away:
http://www.officearticles.com/excel/dealing_with_duplicate_records_in_microsoft_excel.htm
http://www.usd.edu/trio/tut/excel/26.html

Thanks Will!