:Find and reference functions Use the UNIQUE function to remove duplicates-Table skills免费ppt模版下载-道格办公

Find and reference functions Use the UNIQUE function to remove duplicates

  • Picture and text skills

This function needs to be updated to the latest version of WPS Office

WPS Office official website: https://font2020.oss-cn-beijing.aliyuncs.com/wps/


The Unique function can remove duplicate values ​​and retain unique values. This function consists of three parameters: array, column, and only appear once.


分界线.png

Take the removal of duplicate lists as an example. First, select the return area for duplicate removal, then enter the formula =UNIQUE in the bulletin column, and then select the columns or rows that need to be removed.Select the class column here,Because we need to remove duplication between rows, span>So the second parameter inputFALSE,Then enter the third parameterFALSE,Finally press "Ctrl+Shift+Enter" to get the result after deduplication.


录制_2021_08_23_14_27_15_430.gif


But if you enter TRUE in the third parameter, you will get the value that appears only once in the column. Please note that WPS Office does not currently support dynamic arrays, so you must use "Ctrl +Shift+Enter" key shortcut is set to array form.


录制_2021_08_23_14_29_00_762.gif



The biggest difference between the UNIQUE function and the "Delete Duplicates" function in the table is that the UNIQUE function is dynamic.

Take this as an example, we need to add class information to this table.

Step one: Use "Ctrl+Shift+Enter" to confirm the return array area and conditional array range in the deduplication column extension.


录制_2021_08_23_14_29_46_915.gif


Step 2: Paste the new class into the class column. At this time, you can see that the deduplication column will automatically update #N/A to the newly added unique class, and the new Duplicate data in the added class will also be automatically deduplicated and will not be displayed. If a unique value in the class column needs to be deleted, the corresponding position in the deduplicated column will become 0.


录制_2021_08_23_14_30_42_59.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/cha-zhao-he-yin-yong-han-shu-shi-yong-UNIQUE-han-shu-qu-chu-chong-fu-xiang.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
single-end

Related Suggestion