title: How do I remove the rows of duplicates based on a "key" column?
body: <p>I am elaborating an Excel file with a lot of rows, and many of these are duplicates.</p>
  
  <p>I created a "key" column which contains data from 3 of the adjacent columns, and contain the relevant data, and used conditional formatting in order to highlight the duplicates and filter them.</p>
  
  <p>The key column is formatted as: <code>=B1428&amp;" , "&amp;C1428&amp;" , "&amp;J1428</code></p>
  
  <p>This concatenates the cells referenced above, and separates them with a comma.</p>
  
  <p>If i perform the "Remove Duplicates" operation, Excel returns in the same column all the unique data, but it doesn't remove the relative row.</p>
  
  <p>How do I remove the duplicates so that also the relative row is deleted and not just the values?</p>