Compare two excel files

Help
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.

9

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

Regards,