btapack.blogg.se

From the Developer tab, select Visual Basic.įirst, we will use the COUNTIF function to count the first occurrence of a product as 1, its second occurrence as 2, and so on.To enter the above code, copy it and paste it in your developer window. Note: You cannot undo changes made by this VBA script, so we suggest you keep a backup copy of your dataset before running the code. The code then removes all the rows from the range that contain duplicate product names. In the above code, we specified this as Column 1 or the Product Names column. It takes the selected range, as well as the columns that you want to base the duplicate removal on. This code uses a VBA built-in command for removing duplicates in list-objects. Rng.RemoveDuplicates Columns:=Array(1), Header:=xlYes If you are comfortable with a little coding, then you can use this method to remove duplicate rows based on a single column.Įven if you’re not that keen on coding, you can just copy-paste the following code: Sub Delete_duplicate_rows() So instead, you can have the code and add it to the Quick Access Toolbar, so that you can access it with a single click. This method is useful when you have to do this quite often and don’t want to follow many steps. You can do this easily using a short VBA code as well.