Home > Topics > excel > How to filter duplicate data in two columns in wps

How to filter duplicate data in two columns in wps

angryTom
Release: 2020-03-10 14:52:13
Original
54569 people have browsed it

How to filter duplicate data in two columns in wps

How to filter duplicate data in two columns in wps

The first step: Open a wps table that needs to find duplicates in two columns.

How to filter duplicate data in two columns in wps

Recommended study: "Excel Basic Tutorial"

Step 2: Select two columns of data and click to select "Conditional Formatting" "New rule" option in ".

How to filter duplicate data in two columns in wps

How to filter duplicate data in two columns in wps

Step 3: As shown in the figure below, the "New Format Rule" dialog box will pop up.

How to filter duplicate data in two columns in wps

Step 4: Select "Format only unique or duplicate values" and click the "Format" button.

How to filter duplicate data in two columns in wps

Step 5: In the pop-up "Format Cells" dialog box, switch to "Pattern", select a logo color, and click the "OK" button.

How to filter duplicate data in two columns in wps

# Step 6: Click the "OK" button in the "New Format Rule" dialog box.

How to filter duplicate data in two columns in wps

As shown in the figure below, duplicates are identified.

How to filter duplicate data in two columns in wps

For more Excel related tutorials, please pay attention to PHP Chinese website!

The above is the detailed content of How to filter duplicate data in two columns in wps. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template