Remove duplicates in Excel (Easy step-by-step tutorial)

Duplicate values can make information less clear and more difficult to get an accurate assessment. In this tutorial, we'll explore four distinct methods to remove, select or hide duplicates, or simply view your data without duplicates in Excel.


00:00 Intro
00:05 Remove duplicates with built-in functionality
00:42 Select duplicates with Kutools with more options
01:44 Hide duplicates with Advanced Filter
02:21 Copy data without duplicates with Advanced Filter
03:14 Delete duplicates with IF and COUNTIF functions
04:37 View data without duplicates with UNIQUE function (only available in Excel 2021 or Excel 365)