• Skip to main content
  • Skip to primary sidebar

Technipages

Smart phone, gadget and computer tutorials

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
How to Use the Unique Function in Google Sheets

How to Use the Unique Function in Google Sheets

Posted on December 4, 2019 by Mel Hawthorne Leave a Comment

The unique function in Google Sheets can be very useful – when applied to a list with multiple entries that repeat, it provides a second list that only features one of each entry. This means that if you have a list featuring multiple sign-ins from multiple people, you can use the unique function to find out who signed in.

The result of the unique function is a list featuring one copy of each name on the list, without any duplicates. Here’s how to do it.

Step 1: Ready List

Make sure your list is ready and each entry is in one field of your Google Sheet. It doesn’t matter how long your list is, just make sure you know the cells it is located in – you’ll need to enter the range later.

Step 2: Enter Function

The function you need to use is “=UNIQUE(X)”. Copy it without the quotation marks and replace X with the cells that you want to unique. You’ll have to enter the function into the cell where you want your uniqued list to start – click on it and enter it, before selecting the range of cells you want to unique.

A list with the Unique function.

Step 3: Select Range

The range you want to unique has to be expressed like this: “A1:A50”, with the letters and numbers corresponding to the relevant cells. A fully filled out unique function might look like this:

=UNIQUE(A2:A39)

Press enter after closing the bracket and you will see the results of the unique list.

A uniqued list next to the original.

You Might Also Like

  • How to Convert Google Sheets to PDF
    How to Convert Google Sheets to PDF
  • Google Sheets: How to Shade Every Other Row
    Google Sheets: How to Shade Every Other Row
  • Troubleshooting Google Sheets Goes Blank
    Troubleshooting Google Sheets Goes Blank
  • Google Sheets Won't Let Me Type - Fix Guide
    Google Sheets Won't Let Me Type - Fix Guide
  • Troubleshooting Google Sheets Not Printing
    Troubleshooting Google Sheets Not Printing
  • Troubleshooting Google Sheets Not Working
    Troubleshooting Google Sheets Not Working
  • How to Highlight Text in Google Sheets
    How to Highlight Text in Google Sheets
  • How to Spell Check in Google Sheets
    How to Spell Check in Google Sheets
  • How to Set Editing Permissions in Google Sheets
    How to Set Editing Permissions in Google Sheets

Filed Under: Internet, Software Tagged With: Google Sheets

Reader Interactions

Did this help? Let us know! Cancel reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • Fix Skype Error: Exchange Needs Your Credentials
  • Fix Skype Notifications Not Working on Windows 10
  • Teams in Outlook: We Couldn’t Schedule the Meeting
  • VR Oculus Quest 2: How to Configure a New Room-Scale Boundary
  • VR Oculus Quest 2: How to Adjust Boundary Sensitivity
  • Dropbox: How To Change the Date Format
  • Microsoft Teams: There Was a Problem Saving the Photo
  • VR Oculus Quest 2: How to Set up Oculus Link

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

Follow me on Twitter, or visit my personal blog.

You May Also Like

  • Function
  • One-Way Hash Function
  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2021 Technipages · All Rights Reserved · Privacy