How to check name and job number in Excel

How to check the name and job number in Excel? Checking large numbers of names and job numbers in Excel is a tedious and error-prone task. PHP editor Zimo will introduce a convenient method to quickly complete this work using formulas and conditional formatting. Continue reading this article to learn the steps to avoid the hassle and mistakes of manual verification.

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

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

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

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