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>SheetNameSheetNumberAllSheets
|
| 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>FALSETRUE
|
| 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>FALSETRUE
|
| 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>FALSETRUE
|
| 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>LeftEntireColumn
|
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>SheetNameSheetNumberAllSheets
|
| 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>FALSETRUE
|
| 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>FALSETRUE
|
| 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>FALSETRUE
|
| 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>UpEntireRow
|