Excel Tutorial – UNIQUE

The UNIQUE function in Microsoft Excel is a useful tool that allows you to extract a list of unique values from a range of cells. It is a handy function to use when you want to create a list of unique values from a range of cells, such as a list of unique names or a list of unique product codes.

Here is a step-by-step tutorial on how to use the UNIQUE function in Microsoft Excel:

1. Open a new or existing spreadsheet in Microsoft Excel.
2. Identify the range of cells that contain the values that you want to extract.
3. Select the cell where you want to enter the UNIQUE function.
4. Type the =UNIQUE( formula and press the Enter key.
5. In the UNIQUE formula, enter the range of cells that contain the values as the argument.
6. Press the Enter key to complete the UNIQUE function. The unique values will be displayed in the selected cell and the adjacent cells.

Here is an example of a UNIQUE formula:

=UNIQUE(A1:A10)

This formula extracts a list of unique values from the range of cells A1:A10.

You can also use the UNIQUE function to extract a list of unique values from a named range. For example, if you have a named range “Names” that contains a list of names, you can use the following UNIQUE formula to extract a list of unique names:

=UNIQUE(Names)

This formula extracts a list of unique names from the named range “Names”.

In addition to extracting a list of unique values, you can also use the UNIQUE function to extract a list of unique values and their corresponding occurrences in the original range. To do this, you can use the FREQUENCY function as an argument in the UNIQUE function.

Here is an example of a UNIQUE formula that extracts a list of unique values and their corresponding occurrences:

=UNIQUE(FREQUENCY(A1:A10, A1:A10))

This formula extracts a list of unique values and their corresponding occurrences from the range of cells A1:A10.

I hope this tutorial helps you understand how to use the UNIQUE function in Microsoft Excel. It is a useful tool that can help you extract a list of unique values from a range of cells.