WPS 2012 easy to handle table duplicate values

Source: Internet
Author: User

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.

Figure 1

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.

Figure 2

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

Figure 3

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.