Articles with the tag:
Articles with the tag:
Try in the cloud

UNIQUE Function

The UNIQUE function is one of the reference functions. It is used to return a list of unique values from the specified range.

The UNIQUE function syntax is:



array is the range from which to extract unique values.

by_col is the optional TRUE or FALSE value indicating the method of comparison: TRUE for columns and FALSE for rows.

exactly_once is the optional TRUE or FALSE value indicating the returning method: TRUE for values occurring once and FALSE for all unique values.

To apply the UNIQUE function,

  1. select the cell where you wish to display the result,
  2. click the Insert function
    icon situated at the top toolbar,
    or right-click within a selected cell and select the Insert Function option from the menu,
    or click the
    icon situated at the formula bar,
  3. select the Look up and reference function group from the list,
  4. click the UNIQUE function,
  5. enter the required argument,
  6. press the Enter button.

The result will be displayed in the selected cell.

To return a range of values, select a required range of cells, enter the formula, and press the Ctrl+Shift+Enter key combination.

UNIQUE Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action