Thread: Duplicate entries in spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
  
Posts: 703
Default Duplicate entries in spreadsheet
Hello

Use an advanced filter, and select "Unique records only".

Hopes it helps.

Regards,
Per

On 2 Dec., 20:01, Hunt wrote:
Is it possible to filter or sort a spreadsheet (Excel 2007) and automatically
eliminate duplicate entries?

Reply With QuoteReply With Quote