:"WPS table data comparison and quick marking of unique items techniques"-Table skills免费ppt模版下载-道格办公

"WPS table data comparison and quick marking of unique items techniques"

In the supermarket's purchase bill for a week, if you want to quickly mark the products that are only purchased once, you can do the following steps: 1. To mark the unique data in a single area, first click "Data" - "Data Comparison", pull down and click "Mark" unique data". Select the list area in the Mark Unique Data edit box, select the name class in the comparison method, select the color of the labeled data in the specified color, and click the "OK Mark" button. 2. Mark the unique data in two areas and two worksheets. If the supermarket purchases goods on different dates, for example, a new batch of goods is purchased on the 4th, but because the manager has made a mistake in the data, he now wants to quickly mark what additional goods are purchased. You can do this: click "Two Areas" in the Mark Unique Data edit box, select the purchase product details list on the 1st in area 1, and select the purchase product details list on the 4th in area 2. Select the specified color and click the "OK Label" button. Similarly, if there are two different worksheets, you can click "Two Worksheets" to check the worksheet that needs to label data, or click "Select File" to add the file, and then click the "OK Mark" button. Please refer to the following link for related pictures and operation demonstrations: - [Boundary line.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/bf1c4e32af6c6160ff00de2d06f18589.png)- [Mark unique data 1.gif ](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/2439fdcedb5e3a35b5c350ad4edb5d7b.gif)- [Mark unique data 2.gif](https://font2020.oss-cn-beijing.aliyuncs. com/wps/images/1e93764e2e88263bbd1be039acf2466f.gif)-[Mark unique data 3.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/82fe7dde07ccb1305fd15186db508be6.gif)

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/WPS-biao-ge-shu-ju-dui-bi-yu-kuai-su-biao-ji-wei-yi-xiang-ji-qiao.html