How to compare a row in excel with a column in another excel?

[deepaksvg99 (deepak)]

Can any one help me with the logic for how to compare a row in one excel with the data present in the column of another excel?

[arivu96 (Arivazhagan A)]

Hi @deepaksvg99,

Using Read range activity to get the data from two excel sheet.
Then compare the datatable.

Regards,
Arivu

[Lucas.Pimenta]

Hello

You just have to read both excel files using Read Range Activity and then loop through it using the If activity to compare each value.

@EDIT
Check it out those topics. It might help you

Comparison of columns between two excel file using For Each row activity

I need to compare two files based on one column and output to excel file if match is found.can anyone give me the logic how to do it using For each row activity. My current logic as as follows: for each row firstable body: assign the value of the firsttable column value to one variable1 for each row secondtable body : assign the value of the secondttable column value to one variable2 then do compare variable1 = variable 2 can you give me the complete logic to achieve this asap

How to compare two excel data

Hi i have two excel sheet i am comparing Technology to column1 ,Experience in Months to column2, Proficiency to column3, skills to column4 SHEET1 Column-1 Column-2 Column-3 Column-4 Core Java 6 Intermediate Primary JSF 2 Beginner Primary Servlets 2.x 6 Intermediate Primary JSP 6 Beginner Primary JDBC 6 Beginner Primary Jquery 6 Intermediate Primary Core Spring 6 Intermediate Primary Angular JS 6 Beginner Primary Hibernate 6 Intermediate Primary iBatis 2 Beginner Primary Javascript 6…

Compare two columns in excel

How to compare two columns in excel… And printing out back only the matched values to the same excel sheet… ??

Hope It Helps.

Regards,