Contents |
Hold Duplicated Rows
Hold rows in a worksheet based on duplications in one column
wkeepdup num:=2
| Display Name | Variable Name | I/O and Type | Default Value | Description |
|---|---|---|---|---|
| Reference Column | irng |
Input Range | | Specify the column in which duplicated rows will be searched for. |
| Minimum Number of Duplicate to Keep | num |
Input int | | 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 | | Specify whether the duplication checking is case-sensitive. |
| Support Undo | undo |
Input int | | 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 | | Specify the worksheet in which to output the duplicated rows.
|
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.