A backup of this sheet will be created, so I pick Delete values and click Finish without hesitations.Īs a result, I get a clean list without duplicates. On the final step, let's choose the action. Click the 1 header row phrase and enter the number of headers your table has. This means that the add-in will not look at the values in the second and third columns - only at the first one.īy the way, by ticking this box you can exclude the header row from the search. As our task is to get a clear table without repeats in the first column, we choose it as the only key column and uncheck the other ones. As we are looking for duplicate values, we tick the first option. Here we select the type of data we need to find. Excel doesn't let undo changes made by the add-in, so it is better to keep this box checked. ![]() If it is checked, a safe backup copy of your sheet will be created. On the first step, the tool selects your table automatically, but you can change the search range if you select it right in your sheet.īy the way, please do not ignore this box. ![]() Let's start Duplicate Remover by clicking its icon on the Ablebits Data tab. My task is to remove the rows that contain repeated values in the first column. There are three columns, but now only the first column makes a difference - entries in the second and the third ones are not important. ![]() In this quick tutorial, I will show how to remove duplicates in an Excel sheet using the Ablebits Duplicate Remover add-in.
0 Comments
Leave a Reply. |