Duplicate entries in spreadsheet

H

Hunt

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

Per Jessen

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

Duplicate lines in spreadsheet 1
Duplicate Values in Excel 2007 6
Count if or Sum Product 7
Duplicates in a spread sheet 3
Duplicates in Excel 2007 4
Remove Rows That Are NOT Duplicates 4
Identify duplicates in row with conditional formatting 7
LOOKUP VALUE OCCURS >ONCE IN TABLE ARRAY - RETURN LAST OCCURRENCE 6

Top