Hi All… I have to compare 2 columns (the 2 columns are in date formate) in a single excel sheet. if the data is match i have write it to another excel file, if it is not matched that data also have to be stored in another excel file. TIA! :slight_smile:

Hello @soundarya.a Matching Records dt.AsEnumerable().Where(Function(x) x("Col1").ToString.Equals(x("Col2").ToString)).CopyToDataTable Non Matching Records dt.AsEnumerable().Where(Function(x) Not x("Col1").ToString.Equals(x("Col2").ToString)).CopyToDataTable Thanks, Sanjit

Compare 2 columns in a single excel sheet

Help Activities

system (system) Closed September 26, 2022, 10:10am 4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
3 Columns in 2 datatables, compare then store in new datatable Activities activities , studio , script	4	178	March 7, 2024
Compare 2 columns of two sheets , find unmatched rows, copy in different sheet and delete those rows in original workbook Activities excel , activities , question	12	930	October 12, 2023
How to Compare two Columns of different excel Activities excel , activities , question	3	250	September 14, 2023
Compare 2 sheets using 2 column names and get the uncommon data from 2 files Activities datatable , excel , uiautomation , activities , faq	28	977	May 29, 2023
How to compare the two rows in single datatable using LINQ query? Studio studio , question , activities_panel	5	1822	October 27, 2021

Compare 2 columns in a single excel sheet

Related topics