View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default If value occurs more than once then delete all of them

Given the number of requests we seem to get for finding/processing
matches/duplicates, the ways to handle this vary depending on the user's
scenario/criteria. Here's an example project that demos comparing 2 cols
of data and returning results 4 different ways. Look for
"FilterMatches.xls"...

https://app.box.com/s/23yqum8auvzx17h04u4f

--
-
Garry

Free Usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion