Four Ways To Extract Unique Values In Excel

Date:2022-3-3 Author:Sandra

Today, we are going to learn four tips to extract unique values in Excel, or you can think of this as removing repeating data. Let’s get started.

The following list contains many recurring names. Now, we are going to extract all the non-repeating names from it.

Four Ways To Extract Unique Values In Excel

No.1 Advanced Filter

Four Ways To Extract Unique Values In Excel

Select the name area and go to the Data tab to choose Advanced Filter.

Four Ways To Extract Unique Values In Excel
Four Ways To Extract Unique Values In Excel

No.2 Remove Duplicates

Copy the names and paste them into a new column.

Four Ways To Extract Unique Values In Excel

Then go to the Data tab to click the Remove Duplicates.

Four Ways To Extract Unique Values In Excel
Four Ways To Extract Unique Values In Excel

No.3 The COUNTIF Function

Enter this =IF(COUNTIF($A$1:A2,A2)=1,A2,””) in cell B2. And press Enter key.

Four Ways To Extract Unique Values In Excel

Then, double-click the black cross to quickly fill down the list.

Four Ways To Extract Unique Values In Excel
Four Ways To Extract Unique Values In Excel

No. 4 Pivot Table

Enter any number in column B and fill it. Then go to the insert tab to choose Pivot Table.

Four Ways To Extract Unique Values In Excel

Check the option of Existing Worksheet. and select the location, then hit ok.

Four Ways To Extract Unique Values In Excel

Check the name list.

Four Ways To Extract Unique Values In Excel

Ok, We got it. Hope these four tips can do help you.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *