Duplicate entries in spreadsheet

  • Thread starter Thread starter Hunt
  • Start date Start date
H

Hunt

Is it possible to filter or sort a spreadsheet (Excel 2007) and automatically
eliminate duplicate entries?
 
Hello

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

Hopes it helps.

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing columns in two spreadsheets 1
Duplicate lines in spreadsheet 1
Duplicate Values in Excel 2007 6
Eliminate Duplicate Entries in Order to Create Labels Using Mail M 3
Remove Rows That Are NOT Duplicates 4
Duplicates in Excel 2007 4
how do i sort a spread sheet and remove duplication 3
Identify duplicates in row with conditional formatting 7

Back
Top