Formulas > =UNIQUE()
How to Use UNIQUE() in Google Sheets
Description
How To Actually Use UNIQUE() in Sheets
UNIQUE(range, by_column, exactly_once)
Try UNIQUE yourself
Use the UNIQUE() formula to extract unique values from the range A1:A10. The result should list only the distinct values found in that range.
Hints (3)
-
Remember to start with the UNIQUE function.
-
You only need to provide the range as the first argument.
-
Check if there are any duplicates in the range.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the UNIQUE() formula:
Generate a UNIQUE() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses UNIQUE(). 2 free AI generations, no signup. Members get unlimited use.
Generate a UNIQUE() formula