Formulas > =UNIQUE()

How To Use UNIQUE() Function in Google Sheets


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


11Better Sheets Tutorials

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().
Create a sales pipeline quickly in Google Sheets.
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.
Organize leads, life tasks, chores, assignments, anything into a kanban or trello board.
4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.
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!
Demystifying the SumIF Formula. Add up your values based on a condition, even if that condition is a date.
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
Create a duplicate detector with a few google sheet formulas.
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.
Find out how many people attended each event even if they are double counted in attendee lists.

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.


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.