View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Buffgirl71
 
Posts: n/a
Default automatically filter for unique records... or other suggestions

Data / Filter / Advanced Filter
Action: Copy to another location AND
Check the Unique Records only checkbox at the bottom left