Need to clean up data and remove duplicates?
Need to clean up data and remove duplicates?
You've come to the right place.
In this video, learn how to deal with 5 kinds of duplication scenarios in your data and how to deal with them in Excel using various functions +features.
⏱ Topics in this video:
===================
0:00 - 5 kinds of duplicate data in Excel
0:47 - (1) Removing duplicates with the "Remove Duplicate" button in Excel
1:12 - Identifying (highlight) duplicate values in Excel
1:41 - Removing duplicates with a formula - UNIQUE function
2:18 - (2) Removing Duplicate combinations
3:11 - (3) Duplicate values comma separated in a cell - using TEXTSPLIT & UNIQUE functions
5:48 - (4) Removing duplicates but keeping the latest data - manual approach
7:19 - Removing duplicates but keeping the latest data - formula approach
9:56 - (5) Removing duplicates spread across two lists
11:05 - But what if your data is somewhere else, not in Excel?
📁 Sample file:
=============
Practice your data cleaning skills with this remove duplicates workbook -
[ Ссылка ]
📺 Other Data Cleaning Videos
==========================
Drowning down in dirty data?
Refer to my...
Valuable videos for vigorous vacuuming
How to use Power Query in 15 minutes - [ Ссылка ]
Data Cleaning in Excel - 10 Tricks - [ Ссылка ]
Data Cleaning in Excel - 10 PRO Tricks - [ Ссылка ]
Text and Numbers mixed up - use this potion - [ Ссылка ]
How to clean, analyze and present data (masterclass) - [ Ссылка ]
💥 Full Data Cleaning + Advanced Excel course - [ Ссылка ]
~
#Excel #datacleaning #duplicate
Ещё видео!