| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 | Publish Date not found |  0 Views |
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 https://youtu.be/x4RIJM6fcjA
Learn Excel the FAST way, find out how here https://www.excel-university.com/challenge
Subscribe here youtube.com/@UCTVwsjWbfs2UjxfvX5OHhaw
and turn on all notifications for MS Excel time hacks that will make you more productive!
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
