Wdeldup

Menu Information

Remove Duplicated Rows

Remove rows in a worksheet based on duplications in one column

Minimum Origin Version Required: 8.1 SR0


Wdeldup irng:=col(a) sensitive:=1;

Display Name	Variable Name	I/O and Type	Default Value	Description
Reference Column	irng	Input Range	<active>	Specify the column which needs to be deleted duplicated rows.
Keep 1st Duplication	keep1st	Input int	1	Specify whether to keep 1st duplicate row.
Case Sensitive	sensitive	Input int	0	Specify whether to be case sensitive when decide whether the rows are duplicate.
	undo	Input int	1	Specify whether to allow the "undo" ability. If you have enabled it, you can select Edit: Undo to erase the last operation to the worksheet. Note:It is designed for the script usage, not availble from dialog
Output Worksheet	ow	Output Worksheet	<input>	Specify the output worksheet. See the syntax here.
Output Counts	counts	Input int	0	Specify whether to count and output the number of duplicate rows.

This X-Function can remove duplicated rows in a worksheet. It can be accessed from menu, command window.

Suppose a user has data as following and want to remove the duplicated strings in column A

Hightlight the 1st column and select Worksheet: Remove Duplicated Rows from menu to open the dialog. Select the Case Sensitive check box and Output Counts check box
Click OK to delete the duplicated rows. The result should look like