Removing duplicate rows

Jindon, I have just discovered for some reason when using the code with a larger amount of records it is still filtering the rows that contain "Yes" in column G. This wasn't a problem with the small sample sheet I made as it didn't filter out that test duplicate I made.
On the sample worksheet I attached this time there are over 4000 rows, each of which contain "Yes" in column G, so when the code runs it should have no effect, but its not the case.