I have a sheet (and I tried a new blank one) that for some reason is not finding all duplicates.
New entries, some found.
Originals at top.
Most often I have to keep redoing the conditional formatting criteria because it keeps changing the cell format. So I delete the added entries and redo the search I want, but no matter how many times I redo it, it then rechecks and finds the duplicates.
But now, it seems to not detect everything.
I have found duplicates with underscores, so can not be that. I have double checked if any formatting is in there, but on a blank sheet and pasting only values, same results.
What could I be missing?
Thank you.