How to Paste Unique Values in Excel & Google Sheets

This article will demonstrate how to paste unique values in Excel and Google Sheets.

Advanced Filter and Paste Values

You can extract unique values from Excel with an Advanced Filter.

1.  Select your list of data, and then, in the Ribbon, select Data > Sort & Filter > Advanced.

 

 

2.  Make sure (1) Copy to another location is selected and then select the location in the Copy to box.  Then, (2) tick Unique records only and click OK.

 

All the unique cells will be displayed.

3. Now, highlight these unique values and in the Ribbon, select Home > Clipboard > Copy.

4. Then immediately, in the Ribbon, select Home > Clipboard > Paste Values.

The UNIQUE function and Paste Values

If you are using Excel 365, then you can use the UNIQUE function to extract unique values from a list.

1.  In a blank column to the right of  our list of data, we can type in the following formula:

=UNIQUE(B3:B18")

2. As soon as you press Enter on the keyboard, the list will automatically populate below the formula with all the unique values in your data.

3. Now, highlight these unique values and in the Ribbon, select Home > Clipboard > Copy.

4. Then immediately, in the Ribbon, select Home > Clipboard > Paste Values.

 

How to Paste Unique Values in Google Sheets

Google Sheets does not have an Advanced Filter.  YOu can however use the UNIQUE function to extract the uniques.

Once you have done this, you can use the Google Sheets Paste Special > Values only function to paste the unique values.