# Excel UNIQUE Function In this tutorial, we will learn about An Excel Formula called UNIQUE to Remove Duplicate Values in Excel

Here I have a table of 3 different colors named as Red, Blue and, Black. Now I want to remove the duplicate items from the list such that all 3 colors should be unique in the list. So to remove the duplicate items from the list, we will be applying a UNIQUE Formula.

1. Write a UNIQUE function

2. Choose the range of values where 3 colors are mentioned and close the bracket =UNIQUE(B14:B18) 3. Press Enter, Now you will see the duplicate items have been removed from the list and unique items has been placed in the list How to Remove Duplicate Values in a given row?

In this table, according to color-wise, there are 3 different colors which are Red, Black, and Blue. Now there are 2 things inside the table which are different

1. In Red Color there are 2 different entries denominated as 10 and 20 according to Row wise

2. In Blue Color there are common entries denominated as 5 and 5 according to Row wise So here we will remove all duplicates values in a given row by applying Unique Formula

1. Write a UNIQUE function

Now here there are 3 parameters (array, [by_col], [exactly_once]).
The first parameter array means selecting the entire table

2. Select the entire table =UNIQUE(B14:C18, The second parameter [by_col] means to compare and extract. By row = FALSE By column = TRUE.

3. Press FALSE as Return unique rows =UNIQUE(B14:C18, FALSE,

The third parameter [exactly_once] means TRUE = values that occur once, FALSE= all unique values

4. Press FALSE as Return distinct items and close the bracket =UNIQUE(B14:C18, FALSE, FALSE)

5. Press Enter

6. Lastly you will see that the duplicate items have been removed from the given table 