title: Delete row if the cell name already exists in previous row in Excel
body: <p>I ran into a problem, which I cant really seem to solve in excel.
  I have a huge database with 500 000+ rows of data.</p>
  <p>The first column contains a certain name of a product and the other columns show category, website worldwide sales, etc.</p>
  <p>As the dataset collects products from different regions and countries, A lot of them are duplicated in the dataset.</p>
  <p>What I would like to do is if the product name in a certain row already exists then the row should be deleted.</p>
  <p>Im thinking of a function similar or something like: If &quot;cell with product name&quot; can be found in the earlier rows, then delete row, if not keep row</p>
  <p>Thanks for the help in advance!!</p>