If you’ve ever kept a large database in Excel, you know that sometimes you end up with duplicates.  Here’s how you can find the duplicates and delete them. Let’s start with this list of names.

excel-sheet-plain.jpg

First, we’ll select the range of cells we want to search.

excel-range.jpg

Under the Home tab, choose Conditional Formatting.

excel-conditional.jpg

From the drop-down menu, choose Highlight cell values and then Duplicate values.

excel-range-duplicate-values

You can then choose how you’d like the those highlighted fields to look.

excel-range-duplicate-values-colors.jpg

Here’s what it looks like with the duplicate fields highlighted.

excel-range-highlighted-duplicates

I could remove the duplicates manually but there’s a quicker way. Just select the range of cells. Then click the Data tab at the top and choose Data tools.

excel-range-date-tools

Choose the icon for  Remove duplicates that I have circled below.

excel-remove-duplicates.jpg

Then select the columns you want to delete the duplicates from.  This doesn’t matter with my list since I’m only using one column. Click OK.

excel-range-duplicate-values-colors.jpg

Boom!  All of the duplicates are gone.

excel-conditional-duplicates-cleaned.jpg