ExcelBanter - Duplicate entries in spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Duplicate entries in spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/212225-duplicate-entries-spreadsheet.html)

Hunt

Duplicate entries in spreadsheet

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

Per Jessen[_2_]

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?

Ashish Mathur[_2_]

Duplicate entries in spreadsheet

Hi,

In Excel 2007, there is also an option to Remove duplicates (Data Data
Tools)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Hunt" wrote in message
...
Is it possible to filter or sort a spreadsheet (Excel 2007) and
automatically
eliminate duplicate entries?

All times are GMT +1. The time now is 08:33 AM.