Home >Software Tutorial >Office Software >Basic method of checking name and job number in Excel

Basic method of checking name and job number in Excel

WBOY
WBOYforward
2024-04-17 12:07:08843browse

Take the following table as an example. The left side is the original data, and the right side is the data to be checked. To the naked eye, the two tables are somewhat similar.

Basic method of checking name and job number in Excel

First select the original data on the left, and then click [Advanced] in [Data]-[Filter]. In the condition area, select the table to be checked on the right.

Basic method of checking name and job number in Excel

After clicking OK, the data will be filtered out, and then fill the original data table on the left with a color.

Basic method of checking name and job number in Excel

Finally click [Clear] in [Data]-[Filter], all the data will be restored, and then the data without color in the left table is the wrong data, please Check it carefully.

Basic method of checking name and job number in Excel

The above is the detailed content of Basic method of checking name and job number in Excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete