View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kimmie kimmie is offline
external usenet poster
 
Posts: 14
Default 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.