Remove duplicate rows or columns.
Overload Name | Description |
---|---|
Columns | Remove duplicate columns based on values in specified rows. |
Rows | Remove duplicate rows based on values in specified columns. |
Remove duplicate columns based on values in specified rows.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Range | The name or address of the range to remove duplicates from. |
HasHeaders |
Set this to TRUE if the range has headers that should be ignored. The default is FALSE.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CompareRows | A comma delimited list of row numbers within the specified Range to use for the comparison. Example: 3, 4, 7 |
ShiftColumns |
Whether to shift cells left when removing columns or remove the entire column. The default is "Left".
Specify one of the following values or an arbitrary value:
<blank> Left EntireColumn
|
Remove duplicate rows based on values in specified columns.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Range | The name or address of the range to remove duplicates from. |
HasHeaders |
Set this to TRUE if the range has headers that should be ignored. The default is FALSE.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CompareColumns | A comma delimited list of column numbers within the specified Range to use for the comparison. Example: 3, 4, 7 |
ShiftRows |
Whether to shift cells up when removing rows or remove the entire row. The default is "Up".
Specify one of the following values or an arbitrary value:
<blank> Up EntireRow
|