Delete duplicating entries across the worksheet

Originally Posted by p45cal

5 Hours!!
I tested it on A1:AD1004092 (30,122,760 entries); less than 1 minute and a half.

Sir, perhaps you have a super-computer I tried again with the updated code you shared in the picture and it's been 10 mins and still working. Not sure how long it would take now but I am assuming it would take the same time as before. Thank you

And there is no conditional formatting in my file.