How to Filter for Unique Values & Remove Duplicates in Microsoft Excel
Learn how to find and remove duplicates, count unique values among duplicates, and use the new unique function.
At the end, I cover how to use Excel for free on the web. Excel on the web supports conditional formatting to find unique values and duplicates, remove duplicates, and the new unique formula.
The new unique formula is currently only available to Office Insiders. It will be available to all users soon. To try it out, you can opt into being an Office Insider from within Excel.
Here's the sheet I used if you want to follow along:
https://1drv.ms/x/s!AmxrofZZlZ-whId6gyC3j47tETM8Pg?e=nPVUfg
Watch more Excel tutorial videos: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
As full-disclosure, I work at Microsoft as a full-time employee.
Видео How to Filter for Unique Values & Remove Duplicates in Microsoft Excel канала Kevin Stratvert
At the end, I cover how to use Excel for free on the web. Excel on the web supports conditional formatting to find unique values and duplicates, remove duplicates, and the new unique formula.
The new unique formula is currently only available to Office Insiders. It will be available to all users soon. To try it out, you can opt into being an Office Insider from within Excel.
Here's the sheet I used if you want to follow along:
https://1drv.ms/x/s!AmxrofZZlZ-whId6gyC3j47tETM8Pg?e=nPVUfg
Watch more Excel tutorial videos: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
As full-disclosure, I work at Microsoft as a full-time employee.
Видео How to Filter for Unique Values & Remove Duplicates in Microsoft Excel канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
☑️ Top 30 Advanced Excel Tips and TricksHow to Filter in Microsoft Excel2 Ways to Remove Duplicates to Create List of Unique Values in ExcelReturn Multiple Match Results in Excel (2 methods)Dealing with Duplicates in Excel and Finding Unique DataExcel - Find Duplicate Rows Based on Multiple ColumnsTop 10 Most Important Excel Formulas - Made Easy!Top 50 Microsoft Excel Shortcut KeysSearchable Drop Down List in Excel (Very Easy with FILTER Function)How to Use XLOOKUP in Microsoft ExcelHow to easily automate boring Excel tasks with Power Query!Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)Pivot Table Excel Tutorial10 Super Neat Ways to Clean Data in ExcelCompare Two Lists Using the VLOOKUP FormulaCreate Multiple Dependent Drop-Down Lists in Excel (on Every Row)How to Create Drop Down Lists in Cells - The Complete Excel Guide8 Ways To Find & Remove Duplicate Values In ExcelHow to Separate Names in Microsoft Excel