This website or its third-party tools use cookies which are necessary to its functioning and required to improve your experience. By clicking the consent button, you agree to allow the site to use, collect and/or store cookies.
The platform this site runs on doesn't have the option to turn off cookies server side, but you can do that in your browser and then return to the site.
I accept
Deny cookies Go Back

Annielytics.com

I make data sexy

  • About
  • Resources
  • Services
  • Blog
  • Contact
  • Log In

Apr 03 2015

How to Remove Duplicates in Google Sheets Using the UNIQUE Function [VIDEO]

push duplicate data out of your sheets

Google Sheets doesn’t have a Remove Duplicates option, like Excel does. However, you can still use Google Sheets for your duplicate data removal needs! In this video, I’ll show you how to remove duplicate values from a list in Google Sheets using the UNIQUE function. I really wish Excel had this function.

Two other mad-cool Google Sheets functions to check out (that I also wish Excel offered) are the JOIN and SPLIT functions.

Check Out my Marketing Quick Tips YouTube Playlist

You can stay abreast of all of these videos by checking out my Quick Tips playlist or subscribing to my YouTube channel (or click that handy little button in the right sidebar).

You can also check them out here:

Pro Tip: You can cycle through the different videos in the embedded playlist above by clicking the icon in the top-left corner of the playlist and choosing your quick tip video.

YouTube playlist for Annielytics' Tip of the Day

Written by Annie Cushing · Categorized: Google Docs · Tagged: Google Doc Functions, Google Docs, Google Sheets

Leave a Reply Cancel reply

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

CAN I HELP YOU FIND SOMETHING?

‘MAKING DATA SEXY’ IS LIVE ?

Want to learn how to create compelling, aesthetically pleasing charts in Excel? Learn how with Making Data Sexy.

Note: Also offered for Mac

STUFF I BLOG ABOUT

LEARN HOW TO USE ALL THE TOOLS

marketing strategy guide

DIY marketing strategy guide. This guide provides step-by-step instructions on how to perform 66 unique marketing tasks using 15 reputable marketing tools (both free and paid). Steal it for $295! Learn more.

LEARN TO DO A SITE AUDIT

site audit template

DIY site audit template. 20 sections, 215 checkpoints, 100+ explainer graphics, 218 pages, step-by-step instructions. Steal it for $295! Learn more.

LEARN TO DO AN ANALYTICS AUDIT

analytics audit template

DIY analytics audit template. 8 sections, 61 checkpoints, 100+ explainer graphics, 205 pages, step-by-step instructions. Steal it for $295! Learn more.

TO THIS DATA I DO THEE WED

dashboard course

Learn to build dynamic dashboards in Excel with Google Analytics data. 16 hours of video, 3 sample dashboards, 142-page workbook, practice Excel file, and more! Learn more.

FOLLOW ME ON TWITTER

SUBSCRIBE TO MY YOUTUBE CHANNEL

Privacy Policy
  • Email
  • LinkedIn
  • Twitter
  • YouTube

© 2023 annielytics.com