title: Loop through rows and compare values in Excel
body: <p>How would I go about looping through a row of values to see whether or not the row is a duplicate of another row, and then remove the duplicate? For example, in the below screenshot the duplicate rows would be 1 &amp; 8, 2 &amp; 9. I would want to keep 1 and 2 and just remove rows 8 and 9.</p>
  
  <p><a href="https://i.stack.imgur.com/sdLVp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sdLVp.png" alt="enter image description here"></a></p>