# Remove Duplicates Range

> Remove Duplicates Range activity that deletes all the rows that are duplicates in a specified range in Excel.

`UiPath.Excel.Activities.ExcelRemoveDuplicatesRange`

## Description

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

## Project compatibility

Windows - Legacy | Windows

## 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)