Show Duplicates with Conditional Formatting The past two blog posts have been about removing duplicates in Excel and filtering for duplicates in Excel. This week we’ll talk about identifying duplicates. You can use Conditional Formatting to identify duplicate entries. This will identify all entries that have a duplicate. If you plan to delete duplicate entries, I [...]
Tag archives for duplicates
Filter for Duplicates in Excel
Last week we covered removing duplicates in Excel. This week we’ll tackle filtering for duplicates, and next week I’ll show you how to identify duplicated values or unique values with conditional formatting. Using the Advanced Filter, you can take column or columns and eliminate duplicates to leave only unique values. If you are filtering on [...]
category: Excel
About
The McCombs Technology Training Team helps UT Austin business students, faculty, and staff with their technology resources, and with Microsoft Office. The trainers are Holly Green and Ben Bond.
Jeff Hauger, a previous team member, contributed several blog posts.
