Excel - 4 Ways to Remove and Highlight Duplicates - Part 1

In this video, I demonstrate multiple ways to remove duplicates using Excel. We start with a simple list of customer numbers and use Conditional Formatting to highlight duplicate values. Next, I will show how to use the UNIQUE function to list unique values, followed by the method of actually removing duplicates with Excel's built-in feature. For a more complex scenario, I use the CONCATENATE function and helper columns to manage duplicate customer names and numbers, including using COUNTIF for advanced duplicate detection.

Chapters/Bookmarks:
00:00 Introduction to Excel Online Training
00:14 Highlighting Duplicates with Conditional Formatting
01:03 Using the UNIQUE Function to Find Unique Values
01:46 Removing Duplicates with Excel's Built-in Tool
02:23 Handling Duplicates Across Multiple Columns
03:24 Using Helper Columns and CONCATENATE Function
04:55 Advanced Techniques with COUNTIF
06:04 Conclusion and Further Learning

Online Training in Excel, Teams, OneNote, and Copilot
https://courses.chrismenardtraining.com

Unique Function works with
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones

And make sure you subscribe to my channel!

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!