We can now apply a Color Filter to the column. Step 2: Filter the Column for Font or Fill Color The formatting will be applied to the cells that contain duplicates in the column.
Open the Conditional Formatting drop-down menu.If you are using an Excel Table then you can select any cell inside the column and press Ctrl+Space Bar.Ĭtrl+Space Bar is the keyboard shortcut to select the Entire Column of the Table. The first step is to select the entire column that you want to find duplicates in. Step 1: Apply Conditional Formatting for Duplicates Here are the steps to filter for duplicates with conditional formatting.
Checkout my video on a Beginner's Guide to Excel Tables to learn more about this awesome tool. Tables just save a bit of time with this process. I use an Excel Table in this example, but you do NOT need to use Excel Tables for this to work. Thanks again for the great suggestion Jen! ?
#DUPE AWAY ANALYZING PLAYLISTS SERIES#
This technique was suggested by Jen Snyder (a member of the Excel Campus community) on my first video in the 3-part series on Excel Filters. This is quick and easy technique to highlight duplicates and apply a filter to only display the rows that contain duplicates.
The video above covers one technique using conditional formatting. There are a lot of ways to find duplicates in your data set. Filter-for-Duplicates-with-Conditional-Formatting.zip Download Filtering for Duplicates