Excel Training Home

How to use advanced filter in Excel to extract unique records


When an operator enters data into en Excel worksheet he is bound to make errors and also enter duplicate values. The advanced filter feature in Excel along with the extract 'unique records only' can help us to identify the duplicate records and copy the extracted data to another location in the worksheet.


How to use advanced filter in Excel to extract unique records