Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

Learn how to filter for duplicates with conditional formatting in Excel. This video is a free sample lesson from my Filters 101 Course.

https://www.excelcampus.com/filters101

In this video we learn how to quickly filter a column for duplicate values. We first use conditional formatting to highlight the duplicate values in the column. Then we can filter the column by font or fill color that was applied by the conditional format. Finally, we can sort the column in ascending order to group the duplicate values in adjacent rows. This makes it easy to see the duplicates all in one place, and figure out what actions we need to take to remove the duplicates or analyze them further.

Read the article and download the sample file at:
https://www.excelcampus.com/tables/filter-duplicates-conditional-formatting

I use an Excel Table in this video, and I highly recommend learning how to use Tables. I have an entire video on a Beginner's Guide to Excel Tables to help you get started. Here is the link.
https://youtu.be/fJnJTff4Na8

The video above on filtering duplicates is a FREE sample lesson from my Filters 101 Course. Filters 101 is an online course that will help you learn filtering techniques to prepare and analyze your data faster.

Please click the link below to learn more about the Filters 101 Course.

https://www.excelcampus.com/filters101
00:00 Introduction
00:22 Demonstration
03:16 Outro