title: Deleting a row if duplicated then filtered on another column
body: <p>I am filtering a table with loads of horserace information. I have done 7 of 8 filters but I am struggling with the last one. Basically <em>all</em> I need is to look at the column with the time of the race (col B), if there are 2 times the same then obviously there are 2 selections in the race. I only want one selection so next I want to delete/filter row based on column C which is Trainer win %. Whichever is the bigger % that is the one I need to keep. If they are the same maybe put msgbox to say so or I may have to filter with a 3rd field. I have found a piece of code that is getting close.</p>
  
  <pre><code>Sub text()      
  Dim j As Integer, k As Integer, r As Range      
  j = Range("E2").End(xlDown).Row      
  For k = j To 2 Step -1      
      MsgBox k      
      Set r = Range(Cells(k, "E"), Cells(k, "E").End(xlUp))      
      If WorksheetFunction.CountIf(r, Cells(k, "E")) &gt; 1 Then      
          Cells(k, "E").EntireRow. Delete      
      End If      
  Next k      
  End Sub 
  </code></pre>