Embedded Files
The Google Sheets UNIQUE function enables you to pull out unique rows from a range, discarding any data that’s duplicated. This is really handy when you have a large volume of data, such as responses from a Google Form. UNIQUE allows you to quickly identify which values (e.g., a person, or a product name) appear only once in the dataset.
How to use?
How to use?
SYNTAX: ==UNIQUE(range)
range – this is the group of cells that the function references and returns unique or distinct values from
PRACTICE SHEET
The below sheet is view only mode, please make a copy to practice.
Page updated
Google Sites
Report abuse