Menu
EXCEL UNIQUE FUNCTION
Excel UNIQUE Function Introduction
The UNIQUE function in Excel produces a list of unique values inside a specified range. The result is returned in the form of a dynamic array.
Description of Excel UNIQUE Function
Syntax :
=UNIQUE( array, [by_col], [exactly_once])
Parameters :
array – The range or array from which unique values will be returned.
[Optional] by col A logical value indicating whether rows or columns should be compared.
precisely once – [Optional] A logical value that controls whether only values that appear once
Step By Step Guide of UNIQUE Function
Example :
the Excel UNIQUE function is used to extract unique values from a particular range are returned. If the UNIQUE statement is immediately inserted into a cell, the outcome is a dynamic array that will be spilled onto the adjacent cells (not wrapped by another function).
To retrieve all distinct values from a vertical list of text values in B6:B15, for example.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now