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?
Using Read range activity to get the data from two excel sheet.
Then compare the datatable.
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.
Check it out those topics. It might help you
Hope It Helps.