Excel How To Remove Duplicates (3 easy options)

Download File: https://www.excel-university.com/yt_s...

This video provides 3 options for removing duplicate rows from Excel worksheets and data ranges. We talk about single columns as well as multiple columns. Specifically, we cover these items:
Remove Duplicates Command
Conditional formatting (identify duplicates)
The UNIQUE function (and the exactly once argument)
Power Query

Chapters in this video:
00:00 - Introduction
00:10 - Remove Duplicates
01:44 - Multiple Columns
03:26 - UNIQUE
05:09 - Power Query

Watch the previous video: Excel How To Sort a List in Random Order    • Excel How To Create a Simple Dot Plot  

Learn Excel the FAST way, find out how here 👉 https://www.excel-university.com/chal...

Subscribe here 👉    / @excelu  

and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!