![]() ![]() As I want to find the repeated rows only, I check all the three columns, you may have more of course. Now let's select the columns that contain duplicates. If you have more header rows, feel free to click on the 1 header row phrase and enter the needed number. I leave this box checked since my table has 1 header row. The tool selects the table automatically, but we can change the range right in the sheet. This is the short way that saves our time and brings us to the third step of the wizard. I go to the Ablebits Data tab, find the Duplicate Remover icon and click the down arrow below. In this tutorial, I will show how to find and select duplicate lines with the help of the Ablebits Duplicate Remover add-in. ![]() A new sheet in the workbook has been created, this is a backup copy of the original dataset. Now the table has no repeats, only unique rows are left. ![]() On the final step, we tick Delete and hit the Finish button. If needed, you can enter any number of header rows by clicking the 1 header row phrase. We leave the My table has 1 header row box checked since the table has a header row. The utility will delete the row only if it finds duplicate values in all the columns. ![]() If your table has more columns, you can get all of them selected by clicking the Select All button. As our task is to remove the repeated rows, we shall select all the three columns of the table. The wizard wants us to choose the key columns. As we are deleting duplicate lines, we pick the Duplicates option. On the second step, we shall select the type of data to look for. If the Backup this worksheet box is checked, the tool will create a backup copy of your sheet right in this workbook. The add-in will automatically pick the range that you select in your worksheet.ĭealing with duplicates removal in Excel, it is better to have a backup copy of the original dataset then to restore the mistakenly deleted entries. In the Excel ribbon, let's find the Ablebits Data tab and the Dedupe group. Let's have a look at the way we can do it. If your task is to delete duplicate rows from your Excel table, the Ablebits Duplicate Remover tool will help you out. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |