HDTutorial
EN
How to Filter for Unique Values & Remove Duplicates in Microsoft Excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Filter for Unique Values & Remove Duplicates in Microsoft Excel

128,352 views February 2, 2020 8:14

Watch on YouTube
ChannelKevin Stratvert

Description from the creator

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:
1drv.ms/x/s!AmxrofZZlZ-whId6gyC3j47tETM8Pg?e=nP…

Watch more Excel tutorial videos: youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqo…

- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com

As full-disclosure, I work at Microsoft as a full-time employee.

About this tutorial

Kevin Stratvert published this 8:14 video tutorial on February 2, 2020. It has been watched 128,352 times on YouTube.

Duration
8:14
Published
February 2, 2020
Views
128,352
Likes
1,608

Share

This tutorial in other languages