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.

Hi @zellec
Here is a detailed article on that :slight_smile: