3 EASY Ways to Find and Remove Duplicates in Excel
These are 3 easy ways to remove duplicates in your data to create a unique / distinct list of values in Microsoft Excel. It's a very common task for data cleaning and also a very common job interview question. One of the solutions (removing duplicates with power query) returns a different result to the other methods. I'll explain what the difference is and what to watch out for.
★★★ My Online Excel Courses ► https://www.xelplus.com/courses/
Download the workbook: https://www.xelplus.com/excel-remove-duplicates/
Timestamps
00:00 How to Remove Duplicate Values For Multiple Columns
01:15 How to Use the Remove Duplicates Feature
03:09 How to Use the UNIQUE Function
04:50 How to Use Power Query to Remove Duplicates
08:25 Wrap Up
► LINK to more Power Query tutorials: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
Видео 3 EASY Ways to Find and Remove Duplicates in Excel канала Leila Gharani
★★★ My Online Excel Courses ► https://www.xelplus.com/courses/
Download the workbook: https://www.xelplus.com/excel-remove-duplicates/
Timestamps
00:00 How to Remove Duplicate Values For Multiple Columns
01:15 How to Use the Remove Duplicates Feature
03:09 How to Use the UNIQUE Function
04:50 How to Use Power Query to Remove Duplicates
08:25 Wrap Up
► LINK to more Power Query tutorials: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
Видео 3 EASY Ways to Find and Remove Duplicates in Excel канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
When Should you Use the Hash Sign (#) in Excel Formulas?SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)Consolidate & Clean Multiple Excel Sheets in One Pivot TableFilter Duplicate Values in Excel Without Removing ThemSearchable Drop Down List in Excel (Very Easy with FILTER Function)Compare Two Sheets for Duplicates with Conditional FormattingHow to Use Excel Checkboxes | Interactive Checklists & ReportsExcel shortcut keys you SHOULD know!Answering Your Questions: My Age, Nose, Marriage, Background (1 Million Subscriber Milestone)TOO MANY EMAILS? Use THESE Proven Techniques | Outlook tips included10 Amazing (Less Known) Excel Tricks You Should KnowCreate a Pivot Table from Multiple Sheets in Excel | Comprehensive Tutorial!How to Use SEARCH in Outlook to Find Emails FAST!How to Filter for Unique Values & Remove Duplicates in Microsoft ExcelExcel for Accounting - 10 Excel Functions You NEED to KNOW!How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)Return Multiple Match Results in Excel (2 methods)Smart Excel Pivot Table Trick - Choose Your KPI from Slicer (Excel Dashboard with DAX)5 Excel Functions YOU NEED in 2021