Removing duplicate values in multiple columns

[jleasure457]

I'm wondering if theres a way that I can remove duplicates or apply conditional formatting to columns where the values in two columns are identical to those in another row. For example, I would want the formulat to be able to identify that A1 and B1 were identical to B1 and B2. However, it should not trigger a duplicate for any of the other rows including Addidas as there are not other duplicate matches for the year as well as the company.

Company	Year
Addidas	1955​
Addidas	1955​
Addidas	1954​
Addidas	1991​
Addidas	1954​
Nike	1995​
Nike	1996​
Nike	1995​
Steve Madden	1999​
Steve Madden	1997​
Steve Madden	1997​
Steve Madden	1998​

 

[Roger Govier]

Hi
If you have Excel 2010 or later, just select your whole range of data and then from the Data tab select Remove Duplicates.

 

[Kerryx]

Or just download the excel Add-in called Duplicate Remover