See all How-To Articles

How to Paste Unique Values in Excel & Google Sheets

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

pasteunique intro

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.

 

pasteunique ribbon

 

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.

 

pasteunique advanced filter

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.

pasteunique 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")

pasteunique formula

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.

pasteunique 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.

pasteunique gs paste values

 

 

See all How-To Articles