# Remove Duplicates Range

> `UiPath.Excel.Activities.ExcelRemoveDuplicatesRange`

`UiPath.Excel.Activities.ExcelRemoveDuplicatesRange`

Deletes all the rows that are duplicates in a specified range.

## Properties

#### Common

* **DisplayName** - The display name of the activity.

#### Input

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

#### Misc

* **Private** - If selected, the values of variables and arguments are no longer logged at Verbose level.

## Example of Using the Remove Duplicates Range Activity

To exemplify how to use this activity, we have built an automation project which removes duplicate rows in an Excel range.

[Download example](https://www.uipath.com/hubfs/Documentation/WorkflowExamples/18.3%20Examples/Excel/Remove%20Duplicates%20Range.zip)