Artículos con :
Artículos con :
Pruébelo en la nube

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

Volver a la página anterior
Probar ahora gratis Pruebe y tome su decisión No se necesita instalar algo para
ver todas las posibilidades en la acción