VBA code needed: Posting three most appearing text string in a culomn

Hello All,

After many, many unsuccessful attempts to solve this issue using regular Excel formulas, asking for your assistance.
I'm currently building a file which analyze network monitor capture files, and got stuck on the part which the file need to automatically post the "three most appearing text string" in a certian culomn (posting the result at different location then the source).

Further information is attached in the PS.

If anyone know how it can be done, i'll be extremely greatful for your assistance.

Greetings,

Elia.