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
[ Ссылка ]
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 – [ Ссылка ]
○ Microphone - [ Ссылка ]
○ Camera tripod – [ Ссылка ]
○ Studio lights - [ Ссылка ]
○ Dual monitor mount stand - [ Ссылка ]
○ Web camera – [ Ссылка ]
○ Shock mount - [ Ссылка ]
○ Boom Arm - [ Ссылка ]
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – [ Ссылка ]
○ Screenshots – Snagit – [ Ссылка ]
○ YouTube keyword search – TubeBuddy – [ Ссылка ]
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!
