2.2.3.52 wkeepdup

1 Brief Information
2 Command Line Usage
3 X-Function Execution Options
4 Variables
5 Description
6 Related X-Functions

Brief Information

Reduce rows by checking for duplicates in reference column

Command Line Usage

wkeepdup num:=2

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display Name	Variable Name	I/O and Type	Default Value	Description
Reference Column	irng	Input Range	<active>	Specify the column in which duplicated rows will be searched for.
Minimum Number of Duplicate to Keep	num	Input int	2	Specify the minimum number of duplicated rows to keep. If the number of duplications of a row value is less than this value, the row will not be kept.
Case Sensitive	sensitive	Input int	0	Specify whether the duplication checking is case-sensitive.
Support Undo	undo	Input int	1	Specify whether to enable "undo". Note: This variable is designed for the script usage only, and is not available from dialog.
Output Worksheet	ow	Output Worksheet	<input>	Specify the worksheet in which to output the duplicated rows. See the syntax here.

Description

In the num variable, specify the minimum number of duplicated rows to keep. If the number of duplications of a row value is less than the value of num, the row will not be kept.