How to Paste Unique Values in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on September 7, 2023

This tutorial demonstrates how to paste unique values in Excel and Google Sheets.

pasteunique intro

Advanced Filter and Paste Values

One way to extract unique values from a list in Excel is to use an advanced filter.

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

paste unique ribbon

  1. Choose Copy to another location, and then select the first cell of the filtered range in the Copy to box.
    Tick Unique records only and click OK.

paste unique advanced filter

Advanced Filter “pastes” the unique cells into Column D.

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 the list, type in the formula:

pasteunique formula

  1. As soon as you press ENTER on the keyboard, the formula automatically populates as many cells as necessary to list all the unique values from your data.
  2. Now highlight these unique values, and in the Ribbon, go to Home > Clipboard > Copy (or press CTRL + C).
  3. Immediately, in the Ribbon, go to Home > Clipboard > Paste Values.

paste unique paste values

Paste Unique Values in Google Sheets

Google Sheets does not have an advanced filter. You can, however, use the UNIQUE Function to extract unique values.

paste unique gs unique

Once you have the list generated by the formula, use Paste Special > Values only to paste the unique values.

pasteunique gs paste values

AI Formula Generator

Try for Free

See all How-To Articles