Compare two excel files


#1

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


#2

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


#3

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


#4

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


#5

I think, it will not work.


#6

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


#7

@zellec

Comparing two columns by matching row by row?


#8

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