for-loop too slow

[peterschein]

Dear Pros,


I have a for loop for a task that a VLOOKUP would do. I just needed all the matches so the for loop. It served its task but it got too slow.
Can somebody help me turning it into an Array-Macro?

Please Login or Register  to view this content.

I also attached the file with a short description.


Thank you indeed for your help!!


Best regards

Peter

[Fluff13]

How about

Please Login or Register  to view this content.