How do I identify duplicate values in an Excel column?

Hi @jijorhohim98

Then after the loop use another if before writing out_dt.AsEnumerable.Where(function(row) row(“Remarks”).Tostring.Contains(“Duplicate”)).Count.Equals(0)

In Yes don’t write in NO Write the data

cheers