How to remove duplicated data repeated....
If I have the following listed, how do I remove all of the John Smiths? I
want any field showing up 2 or more times removed completely.
Smith, John
Smith, John
Smith, John
Doe, Linda
Schmidt, Steve
Moore, Dave
Moore, Dave
I would like the final report only to show Linda and Steve but remove all
John Smiths and all Dave Moore because they are appearing more than once.
|