Home >Common Problem >How to filter duplicate values in wps
1. First, we open the wps form, and then click Data==Duplicates====Highlight Duplicates==Settings
2. You can see that in our WPS table, the contents of the ninth and tenth rows are repeated with the sixth and eighth rows respectively. How to delete duplicate content in the table in batches?
(Recommended learning: java introductory tutorial)
3. Select the items to be found. Table range - click "Data" in the menu bar - click "Duplicates" in the format bar == Delete duplicates
4. Click "Duplicates" and find "Duplicates" in the drop-down list "Delete Duplicates" - turn on the "Delete Duplicates" checkbox. In the check box, you can set the scope of finding duplicates: for example, I clicked "Full Dizzy" here - and finally clicked "Delete Duplicates" and it was OK. .
5. After deleting the duplicates, there will be no duplicates. The result of my processing here is as follows:
The above is the detailed content of How to filter duplicate values in wps. For more information, please follow other related articles on the PHP Chinese website!