Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Use the UNIQUE Function in Excel? ——Easy Tutorial

Date:2022-5-2 Author:Sandra

Time to learn a new function. Today, we are going to learn the UNIQUE function.

The UNIQUE function can help us returns a list of unique values in a list or a range. So, if you need to extract unique values from the range, you can use this function.

Syntax:

=UNIQUE(array,[by_col,[exactly_once])

Array: It represents a range or array from which to extract unique values.

By_col: How to compare and extract. By row(FALSE) or by column(TRUE). (It’s Optional, and the default is FALSE.)

Exactly_once: Extract the values that occur once (TRUE)or all unique values(FALSE). (It’s optional, and the default is FALSE.)

How to use the UNIQUE Function? Let’s take an example.

There is a duty schedule like below.

How to Use the UNIQUE Function in Excel? ——Easy Tutorial

We can see that Jim is on duty on Monday and Friday. Patton and Nicole are also on duty for two days. Now, we can use the UNIQUE function to extract the unique names and phone numbers.

Enter =UNIQUE(B3:C9) in cell E3 and press Enter key.

How to Use the UNIQUE Function in Excel? ——Easy Tutorial
How to Use the UNIQUE Function in Excel? ——Easy Tutorial
How to Use the UNIQUE Function in Excel? ——Easy Tutorial

That’s quite easy. See you guys next time~

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *