I would like to remove all instances of a duplication in my data, not just leaving behind one of the rows. For example, I would like this data to only return the rows for Mike and Amy and remove both Jen lines.
I actually designed a macro to do just this a while back! Works just like the Unique tool, but outputting ALL the duplicates to the "D" stream. See attached.
Duplicate.yxmc
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
