From the course: Excel: Conditional Formatting for Beginners
Join today to access over 24,900 courses taught by industry experts.
Format based on unique or duplicate values - Microsoft Excel Tutorial
From the course: Excel: Conditional Formatting for Beginners
Format based on unique or duplicate values
- [Instructor] We're looking at the worksheet called duplicate or unique entries in our chapter one file. This list is sorted by ID number. Duplicate data can be a huge problem at times. You're getting data from different sources, people enter data unexpectedly twice. We're looking for some duplicate data here. And in this specific example, what we're first focusing on is whether there are any duplicates for the ID numbers. Let's say that that's important for some of our other lists as well. So let's select column B, go to conditional formatting, highlight cell rules, duplicate values. And we can use the standard formatting of light red fill, dark red text, click okay. Looks pretty good here. As we start to scroll, however, we see duplicates. Now because the list is sorted by the data in column B, these are adjacent to one another. And as we look at this even further though, the entire row is duplicated. So we'd simply want to delete that, and I'll right click and delete. Shift the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.