From the course: Excel: Managing and Analyzing Data

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Find duplicates and stray values with conditional formatting

Find duplicates and stray values with conditional formatting - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Find duplicates and stray values with conditional formatting

“

- [Instructor] Here's a situation where we have duplicate records. We see Bernard Evans is in here three times. Looking over in the Course Completions column, we want to keep the entry that's on Row 4 because it shows his completions are A, B, C, and D. That cell has the most complete values. The one with just a C in it, that might've been when he purchased Course C, but the completion is tied to Row 4. Okay, so we want to identify the duplicates, okay? I'm going to highlight the column. Conditional Formatting, Highlight Cell Rules, Duplicate Values. Leave this at light red fill with dark red text. Okay, let's look at this. Scroll down. Okay, Rich Chauvaine. Right, so I want to delete this one. Hortencia Wallace. Let's delete either one of those because they have the same data next to it. So we could go through and look at the duplicates and clear those out. Clear out the ones that we don't want. Next, names two. Now this is tricky because we cannot apply the Conditional Formatting to…

Contents