View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lost in Microbiology Lost in Microbiology is offline
external usenet poster
 
Posts: 49
Default Duplicate Values

I know how to remove duplicate values using DataFilterAdvanced Filter, is
there a way to see which rows are removed? I need to know which lines were
duplicates.

Thanks