Compare two excel files


Hi Everyone, I would like to ask how to compare the two excel files. Thank you


Compare in what way? Be more specific on what you want to do


I need to compare the column in the excel 1 to another column of excel 2. Thanks


You can do an element exists maybe, like put a condition when reading both files. It’s just a random idea that came through to my mind


I think, it will not work.


But you can put the condition like if element exists (in this case, if the column in excel 1 is in the excel 2 then do something… else do something.

Besides that, I don’t have any other idea in mind



Comparing two columns by matching row by row?


comparing the column of two excel files like searching the row of excel1 to the column of excel2.