Read range Excel, write range only unique values

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?


UP Message

Hi M_L,

You want all unique values of 12 excel file in single list ?

Yes sir, for example if in the 1st and 5th file the number 25145 is in it. I Just need the first of them in a list.

Please help