Remove duplicate data in my case


1d

This is the output: In data no. 4 and 5, the column E and F is the same, may I ask how I can remove the duplicate data?

Use Excel File

  • For Each Row in Excel
    – If CurrentRow(“columnname”).ToString = CurrentRow(“collumname”).ToString
    — Delete Rows (Excel)