How to match two columns with same values in excel
- 藏色散人Original
- 2020-03-10 09:38:3827055browse
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!
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
Previous article：How to merge Excel in batches with WPSNext article：How to merge Excel in batches with WPS