Hey Excel geniuses
I am trying to remove duplicate entries in a large data set, where the values are sometimes switched around. The "Duplicate Values" function in the Data tab have not helped me so far, and I was wondering if u could help me out?
Here is a simple example of the issue I'm facing:
duplicate.values.png
Bookmarks