A specific method to quickly filter out duplicate files in Excel tables

In daily office work, we often need to filter data in Excel tables to find duplicate files. PHP editor Xigua will introduce you a method to quickly filter duplicate files to help you easily solve this problem. Through the following details, you will learn how to use the built-in tools in Excel to efficiently find duplicate files and improve your work efficiency.

Taking the table below as an example, we need to find the data in Table 1 in Table 2.

We first copy the column of Table 1. If it is a different workbook, copy it to Table 2 and press the CTRL plus key to insert it next to it.

Then select these two columns of data and select [Conditional Formatting] - [Highlight Cell Rules] - [Duplicate Values] on the Home tab.

In the pop-up menu, click OK, and the duplicate places will be found!

If you want to single out these data individually, click [Data Tab] - [Delete Duplicates], and all the data will be filtered out.

The above is the detailed content of A specific method to quickly filter out duplicate files in Excel tables. For more information, please follow other related articles on the PHP Chinese website!