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.