Spread Formula Reference
Formula Functions / Functions T to Z / UNIQUE
In This Topic
    In This Topic

    This function returns a list of all the unique values in a cell range.




    UNIQUE function has the following arguments:

    Argument Description
    array [required] Specifies the range or array from which you want to return unique values.
    by_col [optional] Specifies the logical value that indicates how to compare. If this argument is TRUE, it refers to "by column" and if FALSE, it refers to the "by row".
    occurs_once [optional] Specifies a logical value. If this argument is TRUE, it will return unique values that occur only once. In case the value is FALSE, all the unique values will be included in the result.

    Data Types

    Accepts a range or array. Returns a list of unique values.


    For instance - The cell C4 in the following image contains the formula "=UNIQUE(A4:A15)" and returns only the unique customer names from the values in cell range A4 to A15. Based on the number of unique values, the dynamic array formula spills to the cell range C5 to C8 automatically.


    Version Available

    This function is available in Spread for Windows Forms 12.1 or later.