Hi, can you believe this one? Please see attachment.
Sheet with over 2500 rows. Many duplicates.
Conditional formatting (for duplicates) on column G. Found xxxx duplicates.
I decided to remove them with the function "remove duplicate values" on the ribbon.
Removed several hundreds of rows. But: as you can see in the attachment, several rows will stay.
Tried over and over, nothing changes. They stay.
Checked several values with the search function and indeed there are two or more cells with the same value.
I was wondering why........
Anyone?
Thanks.
Bookmarks