I have two excel files , in the first one there are some document no’s which i need to pickup one by one & find them in the other excel, if a match is found then I need to log it.
The problem is that the doc no’s in the first excel can get repeated any number of times and if a match is found then it should continue to pickup the next record, although there can be a possibility that the next record can be the same doc no as the above, refer to the screenshot below :
So according to the above image, the bot should pickup the first record (14669), if match is found then it should ignore the rest of the 3 records and pickup the next record.
How can this be achieved? Any help would be appreciated :)