I get differing results from you for the Overlay (Dup as New Row) sheet. I only get 4 rows with no duplicates:

2025-01-29_231055.jpg

I suspect this could be because you've removed a bunch of rows which might have matched but I'm not 100% sure of that. In order to check could you tell me what settings you used in your frmOverlay userform for each of the 9 available settings therein so that I can run it and compare?

If this is because you've removed those rows could you re-attach a version with the appropriate rows included?