How to Remove Duplicates on Google Sheets on PC or Mac

This wikiHow teaches you how to use the UNIQUE function in Google Sheets to remove duplicate cells.

Steps

  1. Image titled Remove Duplicates on Google Sheets on PC or Mac Step 1
    1
    Go to https://sheets.google.com in a web browser. If you’re not already signed in to your Google account, sign in now. This will display a list of spreadsheets on your Google Drive.
  2. Image titled Remove Duplicates on Google Sheets on PC or Mac Step 2
    2
    Click the file you want to edit. Select a file that contains a column or row that contains duplicate cells.
    Advertisement
  3. Image titled Remove Duplicates on Google Sheets on PC or Mac Step 3
    3
    Click an empty cell. This is the cell where you’ll enter the formula. Choose a cell that is a few columns or rows away from your data.
  4. Image titled Remove Duplicates on Google Sheets on PC or Mac Step 4
    4
    Type =UNIQUE(range). Replace “range” with the range of cells from which you want to receive duplicates.
    • For example, if your data is in the B column from row 2 to 10, type =UNIQUE(B2:B10).
  5. Image titled Remove Duplicates on Google Sheets on PC or Mac Step 5
    5
    Press ↵ Enter or ⏎ Return. This creates a new column or row based on the same range without the duplicates.
  6. Image titled Remove Duplicates on Google Sheets on PC or Mac Step 6
    6
    Replace the original range with the new data. If you no longer want the data that contains duplicate cells, highlight the new data and press Ctrl+C (Windows) or ⌘ Command+C (macOS) to copy. Then, click the first cell in the old range and press Ctrl+V or ⌘ Command+V to paste.
    Advertisement

You Might Also Like

Sign Out of Your Google Account on All Devices at Once
How to
Sign Out of Your Google Account on All Devices at Once
Turn Off Google Safesearch
How to
Turn Off Google Safesearch
Fix the "Google Play Store Has Stopped" Error
How to
Fix the "Google Play Store Has Stopped" Error
Write a Review on Google
How to
Write a Review on Google
Search by Image on Google
How to
Search by Image on Google
Buy a Google Play Gift Card Online on Android
How to
Buy a Google Play Gift Card Online on Android
Access Google Assistant
How to
Access Google Assistant
Restore Google Authenticator
How to
Restore Google Authenticator
Make a Google Account Without Gmail
How to
Make a Google Account Without Gmail
Get a Google Voice Phone Number
How to
Get a Google Voice Phone Number
Apply a Formula to an Entire Column on Google Sheets on PC or Mac
How to
Apply a Formula to an Entire Column on Google Sheets on PC or Mac
Create a Google Profile
How to
Create a Google Profile
Use Google Translate
How to
Use Google Translate
Sort by Number on Google Sheets on PC or Mac
How to
Sort by Number on Google Sheets on PC or Mac
Advertisement

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 2,414 times.
How helpful is this?
Co-authors: 4
Updated: May 25, 2021
Views: 2,414
Categories: Google Applications
Article SummaryX

1. Sign in to https://sheets.google.com.
2. Open your spreadsheet.
3. Click an empty cell.
4. Type =UNIQUE(range)
5. Press Enter or Return.
6. Replace the original range with the new data.

Did this summary help you?
Advertisement