- Picture and text skills
When I was organizing data at work, I encountered a situation where there was too much data and it was inconvenient to organize. How to quickly markThe sameoutputdata?Take this supermarket bill as an example
1. Mark duplicate data in a single area
Click "Data" - "Data Comparison" - drop down and click "Mark Duplicate Data", and click "Single Region" in the pop-up "Mark Duplicate Data" edit box Select the box (C6:H11) in the list area and determine the contrast method, mark color, etc. Click the OK "Mark Button" and you will see the same products marked.
2. Mark duplicate data in two areas
There are running bills for January and February in the same worksheet. How to select the same category of product data in the two sheets?
Click the two areas in the "Mark Duplicate Data" edit box, select January in the "Area 1" box, and select February data in the "Area 2" box. Select the mark color and click the "OK Mark" button.
3. Mark duplicate data in one worksheet and two worksheets
If you want to mark the data in the entire January bill, how can you do it quickly?
Click a single worksheet in the "Mark Duplicate Data" option box and select the desired worksheet from more files
You can also check the open worksheet in the box and click the "OK Mark" button to see the marked content.
SameTo mark two worksheets together, click on both worksheets to check the boxes that need to be marked For the two worksheets, click the "OK Mark" button.
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-ji-qiao-ru-he-kuai-su-biao-ji-biao-ge-zhong-de-chong-fu-shu-ju.html
评论列表(196条)
测试