# 2.2.3.52 wkeepdup

## Brief Information

Reduce rows by checking for duplicates in reference column

## Command Line Usage

 

wkeepdup num:=2 

## 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.

## Related X-Functions

Keywords:data reduction