How to handle duplicate values in a WPS Office 2012 table

In our daily forms of data processing, we often need to deal with the content of duplicate values, such as deleting a column with duplicate values, leaving only one. Also, when you enter data, when there are duplicate values, want to be prompted or in a certain color display and so on. These operations are simple and easy to implement in the WPS Office 2012 table, so let's take a look at how it's done.

Let's take a look at how to quickly delete duplicate data in a column. In the following figure, the name of the "Team Leader" column is duplicated, and we want to delete the duplicate, leaving only one.

If in other Office software, can adopt the Filter method (Advanced Filter method or function + Filter method), the operation process is more or complex, but in the WPS Office 2012 table, realize this kind of function is very simple.

First, we select the data area and click on the data-duplicates-to remove duplicates, as shown in Figure 2.

In the dialog box that pops up (Figure 3), click OK to achieve the effect as shown in Figure 4.

How about this operation is very simple?

When data is entered, hope that when there are duplicate values, there is a hint, or want to have a duplicate value, to a certain color display and other needs, you can use the "rejection of duplicate values", "Highlight duplicate values" and other functions, the operation process is basically the same, we can try their own.