The final output is the data range with unique combinations of product and month. 3.In the Select Duplicate & Unique Cells dialog box, select Unique values only under the Rule section, and check Select entire rows option, see screenshot. 2.Then click Kutools > Select > Select Duplicate & Unique Cells, see screenshot. 1.Select the data range that you want to use.
#Remove duplicate rows in excel code#
Note: You can also use VBA code to delete duplicate rows. Since all products initially had two rows for each month ( Jan-21 and Feb-21), the first appearance of a product in Jan-21 and Feb-21 is kept, while the second is deleted. The information message below pops up that eight duplicates are removed and eight unique rows are left.
First, uncheck Product Price, as you want to compare data by product and month, and click OK.
To delete duplicate values comparing both fields (product and month) and get a unique price for this combination, follow these steps. Again, for Feb-21, there are two prices: $595 (Row 6) and $ 600 (Row 16).
Once venturing into the Data tab, there might be several options in the offering to fiddle with data, but the one which we are after right now is the Remove Duplicates option as indicated below. For example, the product keyboard in Jan-21 has two prices: $1,000 (in Row 2) and $595 (in Row 8). Using Remove Duplicates Option: Now one shall hover the cursor over the Tabs section and click on the one which says Data. First, look at the data set below, containing information about product, month, and price.Īs you can see in the picture above, there are multiple prices for the same product and during the same month. In Excel, you can use the built-in functionality to delete duplicate rows comparing several columns.
#Remove duplicate rows in excel how to#
This tutorial demonstrates how to remove duplicate rows in Excel and Google Sheets.
0 kommentar(er)
