How to Find Duplicates in Excel Fast and Fix Them! (PivotTables and COUNTIFS Trick)

Need to find duplicate records in Excel quickly and fix them? In this tutorial, I’ll show you two easy ways to find duplicates in Excel using a PivotTable and a COUNTIFS formula. If you’re preparing spreadsheet data for a database upload, HRIS import, CRM system, finance system, or any data cleanup project, checking for duplicate record combinations is an important step. In this Excel tutorial, you’ll learn how to identify duplicate records in Excel by counting repeated combinations like Employee ID + Skill, so you can fix errors before uploading your data. First, I’ll show you how to use a PivotTable to summarize your data and quickly spot duplicate records. Then I’ll show you how to use a COUNTIFS formula to identify the exact duplicate rows in Excel directly in your spreadsheet. Example formula used in this video: =COUNTIFS(A:A,A2,B:B,B2) This Excel duplicate-checking method is useful for: • employee records • HRIS uploads • invoice or transaction data • customer or CRM records • inventory lists • database imports • spreadsheet data cleanup What you’ll learn in this video • How to find duplicate records in Excel • How to use a PivotTable to identify duplicates • How to use COUNTIFS to flag duplicate rows • How to clean up Excel data before uploading to a system • How to validate grouped records in Excel If you work with Excel for HR, finance, operations, reporting, or general office work, these tips can help you save time and avoid upload errors. ⏰ TIMESTAMPS 00:00 Find Duplicate Records in Excel 00:28 Example Dataset (Employee Skills Spreadsheet) 00:41 Create a PivotTable to Find Duplicates 01:51 Highlight Duplicate Records with Conditional Formatting 02:24 Identify Exact Duplicate Rows with COUNTIFS 04:35 Reset Sequential Numbering After Removing Duplicates #exceltutorial #pivottable #countifs #datacleaning 📺 WATCH NEXT - Auto Reset Numbering in Excel: https://youtu.be/tinmHCAxoB8 🎓 FREE COURSE - How to Create Fillable Forms in Microsoft Word - A Step-by-Step Guide Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro: https: https://youtu.be/438pCPCSuG4 📎 CHANNEL LINK https://www.youtube.com/@SharonSmith Visit my Channel page on YouTube to see all my videos, playlists, community posts and more! 📄 TEMPLATES Check out my helpful list of templates available for purchase: https://creatoriq.cc/43c51cv Thank you for supporting my channel! 🌟 ⬇️ FREE DOWNLOADS ✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals. 👋 CONNECT WITH ME Visit my website: https://www.sharonsmithhr.com for more information, tools and resources. LinkedIn: https://www.linkedin.com/in/sharonsmithhr Twitter: https://twitter.com/SharonSmithHR Instagram: https://www.instagram.com/sharonsmithlearning/ Facebook: https://www.facebook.com/SharonSmithLearning ⚙️ GEAR 🎙 Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!) 🖱 Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!) 🎥 Screen Recording Software: https://techsmith.z6rjha.net/NZG5b 📗 Green Screen: https://amzn.to/2DnHsY2 📸 Camera: https://amzn.to/39KvpQA 🔌 Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top notch webcam) 📚 RESOURCES ✏️ JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog 🖥️ TechSmith Camtasia Screen Recording: https://techsmith.z6rjha.net/SharonSmithHR Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel! 🙌 SUPPORT THIS CHANNEL - Hit the "$Thanks" button on any video, or - Donate through my PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills. You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much! ❤️ 🎥 PLAYLISTS ➤ Jotform Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD ➤Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv ➤ Excel Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90 ➤ Excel Tips & Tricks: https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW ➤ Word Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45