How to compare two excel sheet

Learn Academy Feedback
,
1

Hi , all

I have a scenario that , I should compare two excel file for example one excel file have id , salary and year column and another excel file is having id and salary column. after comparing the two file id and salary is matches it should show as yes or no in separate excel file along with column id and salary and status column as yes or no. can one guide with this scenario.

2

Hi @mohan2,
The below attachment would be beneficial for you Compare Files.zip (11.9 KB)

3

thank you but my scenario is in excel file 1 you have column id as 1,2,3,4 and salary as 1000,2000,3000 and zone 5,6,7 and excel file 2 column is id 1,2,3,4 and salary 1000,2000,4000. and then output will id and salary column matches it should say yes or no…

4

Hi @mohan2

Here is a detailed article on that :slight_smile:

Regards,