Hi Automation friends,
I have a question, I need to build a bot that opens 12 Excel files, for each month one.
In every file I read Column “A”, colomn “A” contains between the 95.000 - 120.000 rows with material codes in it. Of all the 12 files I have to generate one list with only unique material codes in it, so I have to exclude all the dubble values. Any tips for me how I can exclude the dubbles?