Posts by Tolga


    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:] [Blocked Image:]  [Blocked Image:]