How to perform a comparison between two excel files and remove the lines from a number that can be in both worksheets?

Learning Hub Academy Feedback
, , ,
1

I have two spreadsheets that I need to compare and remove duplicate data by checking a numbering from a column. This numbering can be on both worksheets.
The difference is that one of the spreadsheets contains a status field stating that the numbering has been used before. The other worksheet is always generated with each new execution of the robot and therefore does not contain any information if this number has already been used.

I want him to make this comparison, remove duplicate data and keep only the numbering that was not used.

2

Hello @vinicius.botelho
you can refer Comparing Two excel files - #2 by vvaidya
you have to make change according to your need, above will only give you a start.