Home>Article>Topics> How to quickly find different parts in two excel sheets

How to quickly find different parts in two excel sheets

王林
王林 Original
2020-04-07 10:44:36 31020browse

How to quickly find different parts in two excel sheets

Open a set of excel tables that need to be searched in different places, click the data menu, and select Advanced;

How to quickly find different parts in two excel sheets

After clicking Advanced, it will pop out "Advanced Filtering" window

How to quickly find different parts in two excel sheets

Click the arrow icon on the right side of the "List Area" and use the mouse to select the entire table;

How to quickly find different parts in two excel sheets

In the "Conditional Area" of the advanced window, collect data from another table, as shown below;

How to quickly find different parts in two excel sheets

Collect data from both excel tables Completed, click the "OK" button in the window. At this time, the different data areas of the two excel tables are hidden, and the numbers in the same area are displayed;

How to quickly find different parts in two excel sheets

What we want to find is different data. Now different data areas are hidden. In order to distinguish the same data from different data, we can add colors to the data in the same area;

How to quickly find different parts in two excel sheets

Then, select all the rows of the entire table, then move the mouse to the far left of the row and double-click the left mouse button. At this time, the different data areas of the two excel tables will be displayed, and you can focus on comparing the data in this area. data, that is, the comparison range is narrowed;

How to quickly find different parts in two excel sheets

Recommended related tutorials:excel tutorial

The above is the detailed content of How to quickly find different parts in two excel sheets. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn