Update Column By Comparing two datatables using Linq Query?

[AshwinS2 (Ashwin S)]

Hi @Manish540

Check this

Comparing two columns in Excel sheet but not rowwise

Yes Dominic i have to check each and every value that is under Debit column and have to check if that value is there in Credit column of sheet2 or not. if it has 1 count then it all the rows of that matching debit amount should go to another excel sheet if and if it has either one count or more than 1 then again it should copy that row from sheet1 and send it to another sheet like unreconcile.

Thanks
ashwin S