I want to compare two columns of 1 Excel file with the columns of the other 7 excel files(not sheets). And If it matches with any Excel’s column then I will send a mail to an authority.
please help me to build the logic.
When you say matches the whole column in the same order?
Or there can be unmatched rows also?
Please share some sample input an doutput
Cheers
Hi @Abhoy_Kumar_Mondal ,
We have 1 file original excel we call it’s data.xlsx, read it to get dtData
we have 7 files, we move them to in same folder rename to other name 1-7.xlsx
we use for each file, read each file call this data is dtTerm
use for each to compare columns then use if statement
but can you share your file, I will test for you
regards,