Compare csv's to find similarities and disimilarities

[badita (Mihai Badita)]

Comparing 2 tables in excel and export the differences to the same worksheet

Hi, I’m trying to take the differences between values in 2 excel tables in the same worksheet in excel. Can anyone kindly provide a step-by-step guidance? I attached the spreadsheet I am working on. Table 1 is within column A to H, table 2 is within J to Q, and I want to show the differences starting in column S. Thanks! [image]

Data table comarision and update

I have to compare two datatable .datatable1 ,datatable2 . Match datatable2 value with datatable1…if values match leave them as it …if the values are not matching update with value from datattable2 and write in excel saying that how many rows are updated.