Posts by Tolga

    Hello,


    I have over 800.000 rows so using Vlookup, Index , Match and Array formulas cause extreme slow performance on the file.


    While searching i found VBA scripting dictionary method for lookup in a fast way.


    The problem is that if the key has multiple value, it will not return every of them. It will just show 1 value (the value of last row with the key)


    I need to write all values horizontally like in the 2nd picture (done by manually)


    Could you please help me to tweak the code ?


    [Blocked Image: https://i.ibb.co/xXd883j/1.png] [Blocked Image: https://i.ibb.co/f8NzBT7/3.png]  [Blocked Image: https://i.ibb.co/1nsZ6LV/2.png]