How to check Duplicate records with specific condition/filter Excel

[Doanh]

@James_Callos
Please check my answer

Check Duplicate records with specific condition/filter Excel

Excel application Scope __Read range → Read excel data to a datatable variable (e.g. dtData) __For each row in dtData ____Filter Data Table with below conditions ______Input DataTable: dtData ______Output DataTable: dtDataCheck ______column (0) = row(“Name”).ToString() ______column (1) = row(“Age”) ______column (2) = row(“SurName”).ToString() ______column (3) = row(“Location”).ToString() ____Assign strComment = “” ____If dtDataCheck.Rows.Count() = 1 → Assign strComment = “ok” _…