Find Duplicates

Find the duplicates of excel sheet.

Find the duplicates from a specified excel sheet and store the count of duplicates for the given range into a variable. It removes the duplicate cell values in the specified range if the action property is Remove. The Input sheet should not contain merged cells.

This activity can only be used after the Open Excel File activity.

Input

• Input : ExcelHandle Variable A variable name that references the opened excel filehandle.

Options

• Sheet Name : String Argument The name of the sheet in which the duplicates to be found.

• Range : String Argument The range of excel sheets in which duplicates to be found.

• Action : The action to be applied to the duplicates.

  • None - No actions will be performed.

  • Remove - remove the duplicate values from the specified range.

Output

• Row Count : Integer Variable The variable that stores the count of duplicates found in the excel sheet.