Excel Version: 2021, 365
I am increasingly wondering how some formulas did not exist in Excel before.
This is also the case with uniques.
Example of use
There are many examples when it is necessary to remove all duplicate values in a column, and all of that must be dynamically changeable.
A great feature for such a job is UNIQUE.
It is extremely easy to use.
Syntax
=UNIQUE (array, [by_col], [exactly_once])
- array – Range or array from which to extract unique values.
- by_col – [optional] How to compare and extract. By row = FALSE (default); by column = TRUE.
Make sure that if more columns are selected at the same time, there are more criteria for uniqueness. - exactly_once – [optional] TRUE = values that occur once, FALSE= all unique values (default).