At work, many friends have used Excel software in order to make tables conveniently. So if you want to filter duplicate items in the table and delete them, how should you do it? Details are explained below.

​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​ Take the following table as an example, I want to delete duplicate items in it.

​​Select the table, click [Delete Duplicates] in the [Data] option bar above, and select the columns to be tested and filtered.

Finally, click OK and the duplicate data will be deleted.

If you only want to mark the filtered data, you can click the [Data] menu bar, click [Auto Filter], cancel [Select All], and check the items to be filtered to see whether there are duplicates in the data items. , the number of repetitions.

Friends who still don’t know the detailed steps of filtering and deleting duplicates in Excel, don’t miss this article brought by the editor.