View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WMark WMark is offline
external usenet poster
 
Posts: 3
Default How do I identify matching rows of data and delete them both?

I have two worksheets...and have merged them, for now, in an attempt to
identify the rows that are common to both. Those that are common to both
worksheets I want to delete from the merged file. Does anyone know how this
can be accomplished without sorting then manually deleting the matches?

Thanks in advance,