You are here LEARN EXCEL & VBA Excel Tips Excel General Filter unique lists with multiple columns with the Advanced Filter function in Excel

Query, Share and Manage Excel workbooks on LAN, Internet

Filter unique lists with multiple columns with the Advanced Filter function in Excel

In many cases when using Excel with large duplicate data tables, to filter the unique list with multiple columns we use the Advanced Filter function with the Unique select attribute in Excel. This article will guide you step by step to implement.

Introduction

Step 1: Blackout the source data table with duplicate data.

Step 2: Go to the Data function in the Excel menu, select "Advanced". The installation window pops up.

We proceed as follows:

Select "Copy to another location".

In the "Copy to" section, select the cell you want to extract.

Select "Unique records only"