excel formula to remove duplicates from a list

EXCEL FORMULA TO REMOVE DUPLICATES FROM A LIST HOW TO

The task: Remove the duplicates from the list of clothing types (i.e. Whether this data has duplicates or not, depends on how many columns are considered. The image below shows a list of clothing items, the colors of the items, and the sizes of the items. We will start by referring to a single column, and then in the next examples we will actually refer to multiple columns.īut it will be beneficial to start with a single column, so that you can see how the result changes when you add more columns into the reference. Let's use a different example, where the original data that has duplicates in it, has multiple columns. Using the UNIQUE function with a larger data set The formula: The formula below, is entered in the blue cell (C2), for this example The logic: Use the UNIQUE function in column C to create a unique list of names, by referring to the list of names in column A

EXCEL FORMULA TO REMOVE DUPLICATES FROM A LIST HOW TO

How to remove duplicates with the UNIQUE functionįirst let's start with a simple example, and remove the duplicates from a list of names that are in a single column. Rows are returned in the order in which they first appear in the source range.” The Google Sheets UNIQUE function description:įormula summary: “Returns unique rows in the provided source range, discarding duplicates. The diagram below shows how the UNIQUE function works. Here are the Google Sheets UNIQUE formulas: This article focuses on using the UNIQUE function to remove duplicates, but you can also use the menu option to remove duplicates in Google Sheets. Press 'Enter' on the keyboard, and the entire formula will appear like this: =UNIQUE(A1:A15)Īfter following the steps above, any duplicates that were contained in the range A1:A15 will be removed, and the unique list will be displayed, starting at cell B1.

Type the range that contains the data you want to remove duplicates from.

Select the cell where you want to enter your UNIQUE formula.

To remove duplicates with the UNIQUE function in Google Sheets, follow these steps: The UNIQUE function is an incredibly useful function in Google Sheets, that can be used to remove duplicate entries, or in other words duplicate rows.

Excel formula to remove duplicates from a list