title: Delete Duplicate Rows from Table based multiple Columns check and Table size remains same
body: <p><a href="https://i.stack.imgur.com/UPyht.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UPyht.png" alt="Table has been created with Header from B63:V1562" /></a>
  In my Workbook, I have Table named as &quot;MyTable&quot; and it has ranges from B63:V1562. (1500 Rows Max)</p>
  <p><strong>I would like to compare the Column B,C,G and H. If these column values are identical or Duplicate with other rows, I would like to clear the contents of those rows and fill with next valid row values.</strong></p>
  <p>The concern over here as, Column L,M and V is having the Formulas. It should not get disturbed due to removal of this duplicates. All Columns having proper mapping with each other column of Data.</p>
  <p><strong>Table size also should remain same.</strong></p>
  <p>Please help me to figure out the solution for the same.</p>
  <p>Thank you so much for your time and Valuable Responses.</p>