Count strings in Excel

[Madhavi (K)]

This might help!

Compare two datatables and get mismatched records

Try this, Get rows that exists in dtTable1 but not in dtTable2 dtDifference= dtTable1.AsEnumerable().Except(dtTable2.AsEnumerable, DataRowComparer.Default).CopyToDataTable Get rows that exists in dtTable2 but not in dtTable1 dtDifference= dtTable2.AsEnumerable().Except(dtTable1.AsEnumerable, DataRowComparer.Default).CopyToDataTable Hope this helps. Let me know if it doesn’t.