Deletes all the rows that are duplicates in a specified range.
- DisplayName - The display name of the activity.
- Range - The range from which you want to remove duplicate rows. This field supports only strings and String variables.
- SheetName - The name of the sheet in the workbook where the change must be made. This field supports only strings and String variables.
- Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
To exemplify how to use this activity, we have built an automation project which removes duplicate rows in an Excel range.
Updated about a year ago