Hi, all
I have a column of entries, with a duplicates flag at the top. It indicates if there are duplicates present in the entries ("DUPLICATES"), and is blank ("") if there are no duplicates. It works well -- until I filter the list using an auto-filter. Because the formula looks at all entries, filtered and unfiltered, then if there are duplicates, the flag is raised, even if in the filtered list no duplicates are visible. I want the flag NOT to raise if the filtered list does NOT contain duplicates, AND to raise if the filtered list does contain duplicates.
Normally I wouldn't filter on the column itself, but to keep the example file simple, I have done so.
The first worksheet shows an unfiltered list with duplicates, with the duplicates flag raised.
The second worksheet shows a filtered list without duplicates, but the duplicates flag is incorrectly raised, and should not.
Can somebody suggest an improvement to this formula? Many thanks in advance.
Bookmarks