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


show more Using a specialized array formula to identify data that's been duplicated provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010 show less
please wait ...

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

As fast and easy as the Remove Duplicates command is to get rid of duplicate data, what it does not do for you is indicate what has been duplicated. So for example, in this list here which does have duplicates in it, there is a Juan Bishop in Row 5, also one in Row 10. If we want to identify which records have been duplicated before getting rid of them, what we need to do is sort the data. So I do have another list here, an exact list, but it has been sorted, clicking over here.

And in this list we will see two Juan Bishops together. If you do want to identify duplicate records here, what we need to do is after doing the sorting, insert a new column to the left of Column A. And what we are going to do here is to put in a formula. I want to show you or start off at least with the long way and then show you a nice quick way using an array formula to identify which records have been duplicated. So, here's the formula I am going to put in here. I can start probably in Row 2.

It's good t...

Using a specialized array formula to identify data that's been duplicated
Video duration: 5m 10s 1h 32m Appropriate for all

Viewers:

Using a specialized array formula to identify data that's been duplicated provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...