Hi,
How would I go about deleting duplicates in such a fashion, that it also deletes the original values which matched the duplicates and leave uniques only?
To illustrate:
AAA
BBB
AAA
CCC
BBB
Should after removing duplicates leave only CCC instead of AAA, BBB, CCC
Example:
Check in column B, D, E. If the values all match, delete both originating rows
Bookmarks