From the course: Excel 2016: Managing and Analyzing Data

Unlock the full course today

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

Using a specialized array formula to identify data that's been duplicated

Using a specialized array formula to identify data that's been duplicated

From the course: Excel 2016: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Using a specialized array formula to identify data that's been duplicated

“

- [Voiceover] This worksheet is called IdentifyingDuplicates and if you saw the previous movie you would know that by looking at the data here if we wanted to get rid of duplicate records we could simply do that with the Remove Duplicates feature found on the Data tab, but let's say what we really want to do here is identify which records have been duplicated. So it is important that the data be sorted. We'll click in column A, click the AZ button, we've got a sorted list, if any two people have the same name they'll be together, but we won't be checking just the names, we'll be checking all the other columns as well. So let's add a new column by right-clicking column A, Insert. Now I wanna show you two methods of identifying whether there's a duplicate or not. We'll start in cell A2 and type =if. We're gonna be using the IF function along with the AND function. And here's what we're about to say using and we're…

Contents