Remove duplicates in excel while its in lowercase or uppercase

[syedabidraza (syed)]

Try this

How to remove duplicate from excel

Hi @cheersrpa i consider the columns “Employee Number” and “COR” to remove the duplicate records. the output of this will be a datatable with 3 row. Here is the workflow for the same - Testing.zip (2.0 KB) You can specify the actual columns that you want to consider to check duplicate in Assign statement instead of below specified columns- dtData.DefaultView.ToTable(true, “Employee Number”, “COR”)