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/uploads/2024/07/remove-duplicates-howto-raw.xlsx 📺 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 - https://youtu.be/UAFExySaSPY Data Cleaning in Excel - 10 Tricks - https://youtu.be/q7EpoOwBcnM Data Cleaning in Excel - 10 PRO Tricks - https://youtu.be/SNVjndgWBlw Text and Numbers mixed up - use this potion - https://youtu.be/bSaLlNLAW44 How to clean, analyze and present data (masterclass) - https://youtu.be/H6k28jhclwI 💥 Full Data Cleaning + Advanced Excel course - https://chandoo.org/wp/excel-school-program/ ~ #Excel #datacleaning #duplicate