Remove duplicates according to data in 2 columns by priority in Excel <p>I am trying to remove duplicates in Excel by comparing 2 columns and by priority, meaning:</p> <p>I have priority by category such as cat 1 > cat 2 > cat 3 > cat 4</p> <p>And I want to match if some text that appears in column 2 and 4 matches any other row it will delete the row that has the lower category priority</p> <p>Here is an image: <a href="http://i.imgur.com/aN3cQwL.png" rel="nofollow">http://i.imgur.com/aN3cQwL.png</a></p> <p>Explanation of the image: Orange cells should be deleted, blue ones should be kept.</p> <p><strong>Update:</strong></p> <p>What I am trying to achieve: I have a list of URLs in column B (Source URLs), another list of URLs in column C (which are target URLs of links), anchor text in column D, column A contains the data source to help me identify from where I pulled the data from. I just want to make sure that there aren't any duplicates between all data sources but maintaining a certain priority, which will prefer to delete duplicates from Category 2 if the exact source URL and anchor appear in Category 1 and etc.</p>