How to Remove Duplicate Values in Excel - Data Cleaning Tips🧹
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 -
https://chandoo.org/wp/wp-content/upl...
📺 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 - • How to use Power Query in Excel - Perfect ...
Data Cleaning in Excel - 10 Tricks - • Data Cleaning in Excel - 10 Tricks (Beginn...
Data Cleaning in Excel - 10 PRO Tricks - • Data cleaning in Excel - 10 tricks *PROs* ...
Text and Numbers mixed up - use this potion - • Data Cleaning PRO Tip: Dealing with text &...
How to clean, analyze and present data (masterclass) - • How to Clean, Analyze and Present Data wit...
💥 Full Data Cleaning + Advanced Excel course - https://chandoo.org/wp/excel-school-p...
~
#Excel #datacleaning #duplicate