Better Sheets

Explore ↓

Free ↓

Login
Get Instant Access

Formulas > =UNIQUE()

How To Use UNIQUE() Function in Google Sheets

Description

Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range.

Common questions about the UNIQUE formula include:
1. What does the UNIQUE formula do? Returns only one item per it's inclusion in a list.
2. How do I use the UNIQUE formula? Use the UNIQUE formula in Google Sheets
3. What are the arguments for the UNIQUE formula?  Range

How can the UNIQUE formula be used appropriately?
The UNIQUE formula can be used to return a list of unique values from a range of cells. It can be used to identify duplicate values in a range of cells, or to create a list of unique values from a range of cells.

How can the UNIQUE formula be mistyped?
The UNIQUE formula can be commonly mistyped as UNIQUEIF, UNIQUEVALUE, or UNIQUEVALUES.

Some common ways the UNIQUE formula is used inappropriately include using it to return a list of duplicate values, or using it to return a list of values that are not unique.

Common pitfalls when using the UNIQUE formula include forgetting to specify the range of cells to be evaluated, or forgetting to specify the criteria for the UNIQUE formula.

Common mistakes when using the UNIQUE formula include using the wrong range of cells, or using the wrong criteria for the UNIQUE formula.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK(). 

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

There are no shortcuts to becoming a Google Sheets pro! Learn more here at Better Sheets

Watch the magic for yourself. Video tutorials at every turn here at Better Sheets.

Your spreadsheets will never be the same again.

How To Actually Use UNIQUE() in Sheets

UNIQUE(range)
Google Docs Help

13Better Sheets Tutorials

▶

Alejandro Asks: How do I Sum up Study hours from a Calendar Format?

A member, Alejandro, asks about taking their custom calendar inputs and figuring out study totals for a week. They created a beautiful input and just need to the calculations. I show how to use the data to do the calculations. If you've never used the FLATTEN() formula, this is a good example! And we use double UNIQUE().
FLATTEN() FILTER() SUM() UNIQUE() SORT()
▶

Make a Quick Pipeline (For Sales and More)

Create a sales pipeline quickly in Google Sheets.
Beginner
UNIQUE() TRANSPOSE()
▶

Discover Misspelled Duplicates

Discover effective methods to handle misspelled duplicates in Google Sheets using formulas without destroying your data. Search and find duplicates that are spelled differently.

Unveiling the Art of Taming Misspelled Duplicates: A Harmonious Symphony of Google Sheets Tricks and Tips

Embark on a captivating journey as we unravel enchanting secrets in this video guide.

Discover an ethereal dance of formulas that transcends the limitations of Google Sheets' native features, gracefully addressing the conundrum of misspelled duplicates. 

Delve into the profound intricacies of the issue, where statuses and names intertwine, inviting chaos into your CRM or meeting records. 

Witness the mesmerizing revelation of unorthodox yet elegant techniques that preserve your data's essence without sacrificing its integrity. Unveil the hidden world of the duplicate detector, where rows are harmoniously synchronized, leaving no spelling errors unnoticed. 

Prepare to be enchanted by the sublime artistry of equals unique, a symphony of transformation that transforms hundreds or thousands of rows into a carefully curated masterpiece. Immerse yourself in this poetic quest and unlock the mystique of finding truth amidst a sea of missteps.
Beginner
UPPER() ARRAYFORMULA() UNIQUE() SORT() LOWER() +1 more
▶

Organize Anything! - Build a Kanban Board / Trello Board

Organize leads, life tasks, chores, assignments, anything into a kanban or trello board.
Advanced
UNIQUE() COUNTA() FILTER() TRANSPOSE()
▶

This Seems Like Automation

4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.
IF() FLATTEN() TRANSPOSE() UNIQUE() IFERROR() +1 more
▶

Clean Up Names in a List

In this video, I will show you how to clean up a list of names that may have extra white spaces using a formula. I will demonstrate how to identify and remove the extra spaces programmatically, making the list of names unique. By using the TRIM formula, we can easily clean up the names and create a new list with only the unique names. No action is required from you, just watch and learn!
Beginner
TRIM() UNIQUE()
▶

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition, even if that condition is a date.
SUMIF() UNIQUE()
▶

5 Ways To Use Google Sheets for Advanced Project Management

Here are 5 advanced ways to manage projects inside of Google Sheets Manage Task Flow with IF() and a Checkbox Manage Data Inputs with IF() and ISBLANK() Create Quick Dashboard headers with: Transpose / Unique Create Pickers with Index / Match Email reports with Apps Script
Intermediate
IF() ISBLANK() TRANSPOSE() UNIQUE() COUNTIF() +3 more
▶

How to Find Duplicates and create a Duplicate Detector

Create a duplicate detector with a few google sheet formulas.
Beginner
MATCH() IF() ROW() CONCATENATE() COUNTA() +1 more
▶

Count How Many Subscribers In a Company by BetterSheets.co

I download it from MailChimp and then I try to figure out which companies are subscribed to me most. And I do, I have to figure out the domain and count the domain. And we're gonna do that all in Google Sheets.
Intermediate
COUNTIF() SORT() LOWER() SPLIT() UNIQUE() +1 more
▶

Count Unique Attendees For Each Event

Find out how many people attended each event even if they are double counted in attendee lists.
Beginner
COUNTUNIQUEIFS() UNIQUE() COUNTUNIQUE() SUM() FILTER()
▶

Americano Tournament Template With Four Automations

Created a tournament template with 4 automations. So tabs can be copied by a laptop, ipad, or mobile.
Intermediate
UNIQUE() SORT() SUMIF() SUM()
▶

Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

Analyze sales with COUNTUNIQUEIFS Formula. 
Intermediate
TEXT() COUNTUNIQUEIFS() COUNTA() FILTER() UNIQUE()

Learn more about the UNIQUE() formula:

Google Sheets - Remove Duplicate Data with the UNIQUE Function

Duplicate data can be a chore to find and remove in a spreadsheet. The UNIQUE function does it quickly and easily.

Generate a UNIQUE() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.

Asa

Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons