Remove Every Iteration of a Duplicate

[jenner85]

Hi - 

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. 

Name	Area
Jen	Ottawa
Jen	Toronto
Mike	Ottawa
Amy	Vancouver

Thanks!

Jen 

[danrh · Accepted solution]

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.