How to match two columns with same values in excel

How to match two columns with the same value in excel?

1. Select columns B to F, go to Start-Conditional Formatting-New Rule, enter the formula as shown below, select the fill color as yellow in the format, and then the colored cells are two columns Common parts of the data

2. Select columns B to F, go to Start-Sort and Filter-Custom Sort, sort the cells, and put the colored ones at the top, so you can quickly find all two columns. Duplicate data

The above is the detailed content of How to match two columns with same values in excel. For more information, please follow other related articles on the PHP Chinese website!