Remove duplicates and place in new sheet

[mn072065]

Hi some help. I want to take my movie catalog and remove all my duplicate maybe triplicates and move to a new sheet so i can begin process of elimination. here is a sample of my log, but i have some movies that are technically not duplicate because its from a diff year, i appreciate the help.

Index Location Title Audience Rating Format Movie Release Year

5228 63 American Violet DVD 2008
5626 24 American Violet DVD 2008
4982 16 An American Werewolf in London DVD 1981
7547 HD 15 AMERICAN_DAD_VOLUME_5_D1 DVD; Files
7548 HD 15 AMERICAN_DAD_VOLUME_5_D2 DVD; Files
7549 HD 15 AMERICAN_DAD_VOLUME_5_D3 DVD; Files
10324HD 22 AMERICAN_GRAFFITI_PACK DVD
2776 HD 7 AmericanRifleman-PersonalFirearmDefense DVD; Files
1246 58 Amexicano DVD 2007
8084 78 Amistad DVD 1997
5583 1 Amityville 2: The Possession DVD 1982
5581 1 Amityville 3-D DVD 1983
5587 1 Amityville Dollhouse DVD 1997
5624 1 The Amityville Horror R (Restricted) DVD 2005
5572 1 The Amityville Horror DVD 1979
4994 1 The Amityville Horror R (Restricted) DVD 2005
16173 The Amityville Horror R (Restricted) Blu-ray Disc 1979

 

[Joe4]

Just copy the complete list to a new sheet, select all the data, and use Excel's built-in "Remove Duplicates" functionality (found on the "Data" menu).
You can specify which columns to include when determining what is a duplicate.

 

[mn072065]

Joe4 if i do what you say, i don't know the duplicates. I want the duplicates seperated so i can work on them. Thanks

 

[Joe4]

Take a look at this other thread here, which shows you how you can identify the duplicates.
https://www.mrexcel.com/forum/excel...rmatting-countifs-formula-duplicate-rows.html

If you sort your data, and apply the Conditional Formatting or COUNTIFS formulas, you can identify the duplicates.
Note if you do not want the first record to show up as the duplicate, you can cut the formula in half, as you only need to compare the current record to the one above it (and not the one below it).

 

[mn072065]

i got it thanks buddy, i feel stupid. But much appreciated.

 

[Joe4]

i feel stupid

You shouldn't. It was a good question. It can be a little tricky sometimes when checking for duplicates and multiple fields are involved (especially when you are not just trying to eliminate the duplicates).