Uploaded March 2023 | Updated September 2026, 17 hours ago
🔥 Join 500,000+ professionals upgrading their skills today 👉 link.xelplus.com/yt-d-all-courses
Struggling with duplicate data in Excel? Discover four innovative methods to identify and eliminate duplicates, whether in columns, rows, or across your entire dataset.
⬇️ Download the file I use in the video: xelplus.com/excel-find-and-highlight-duplicates/#download-section
What you will master in this guide:
▪️ Basic Highlighting: Compare two columns and find overlaps in under 30 seconds.
▪️ Duplicate Row Detection: Learn the "Unique Key" trick using CONCAT to compare entire rows.
▪️ Dynamic Formula Logic: Using COUNTIF to return True/False or the number of occurrences.
▪️ Automated Lists: How to extract a sorted list of only the duplicate entries.
▪️ Clean Dashboards: How to hide helper columns and use Emoji Flags for pro-level visuals.
00:00 Common Problems: Why basic highlighting isn't enough
00:31 Method 1: Highlighting Duplicates Across Two Columns
01:45 Method 2: How to Find Duplicate Rows (The Unique Key Trick)
02:23 Tutorial: Using CONCAT to compare entire row contents
03:11 Method 3: Using COUNTIF to flag occurrences with formulas
04:24 Advanced Logic: Creating a Helper Column for Row-Level Flags
05:13 Pro Tip: How to use Emoji Flags & Group Columns
06:03 Conditional Formatting: Highlighting the entire duplicate row
06:43 Method 4: How to Return a Separate List of Duplicates
07:47 Auto-Sorting Your Duplicate List for Easy Cleanup
08:09 Next Steps: How to Remove Duplicates Permanently
In this video I'll show you 4 ways on how to find duplicates in your Microsoft Excel data. We'll find solutions regardless if your data is in the same column, in separate columns and even if you need to find duplicates for a combination of cells.
You'll learn how to use conditional formatting to color duplicate values, how to look inside an entire row and compare one row with another and flag it is a duplicate. As a bonus you'll learn how to use a dynamic formula to flag duplicate entries with an icon or returns just the duplicate entries.
🎬 LINKS to related videos:
3 EASY Ways to Find and Remove Duplicates in Excel: youtu.be/ADArCWLz55Y
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
🔥 Join 500,000+ professionals upgrading their skills today 👉 link.xelplus.com/yt-d-all-courses
Struggling with duplicate data in Excel? Discover four innovative methods to identify and eliminate duplicates, whether in columns, rows, or across your entire dataset.
⬇️ Download the file I use in the video: xelplus.com/excel-find-and-highlight-duplicates/#download-section
What you will master in this guide:
▪️ Basic Highlighting: Compare two columns and find overlaps in under 30 seconds.
▪️ Duplicate Row Detection: Learn the "Unique Key" trick using CONCAT to compare entire rows.
▪️ Dynamic Formula Logic: Using COUNTIF to return True/False or the number of occurrences.
▪️ Automated Lists: How to extract a sorted list of only the duplicate entries.
▪️ Clean Dashboards: How to hide helper columns and use Emoji Flags for pro-level visuals.
00:00 Common Problems: Why basic highlighting isn't enough
00:31 Method 1: Highlighting Duplicates Across Two Columns
01:45 Method 2: How to Find Duplicate Rows (The Unique Key Trick)
02:23 Tutorial: Using CONCAT to compare entire row contents
03:11 Method 3: Using COUNTIF to flag occurrences with formulas
04:24 Advanced Logic: Creating a Helper Column for Row-Level Flags
05:13 Pro Tip: How to use Emoji Flags & Group Columns
06:03 Conditional Formatting: Highlighting the entire duplicate row
06:43 Method 4: How to Return a Separate List of Duplicates
07:47 Auto-Sorting Your Duplicate List for Easy Cleanup
08:09 Next Steps: How to Remove Duplicates Permanently
In this video I'll show you 4 ways on how to find duplicates in your Microsoft Excel data. We'll find solutions regardless if your data is in the same column, in separate columns and even if you need to find duplicates for a combination of cells.
You'll learn how to use conditional formatting to color duplicate values, how to look inside an entire row and compare one row with another and flag it is a duplicate. As a bonus you'll learn how to use a dynamic formula to flag duplicate entries with an icon or returns just the duplicate entries.
🎬 LINKS to related videos:
3 EASY Ways to Find and Remove Duplicates in Excel: youtu.be/ADArCWLz55Y
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
