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.

Hello,

Thanks for the quik replay.

Adding a file as an example for what is needed.
I'm not familiar with the pivot options regarding this issue.

I'll be glad to know if you have any sulotion possible using VBA.

Greetings.

Elia.Analysis tool - VBA needed.xlsx

Hi..

Try this..

It uses a combination of .ArrayList to get Unique values and then sort them .. and then some funky formulas to do the rest..

Formulas were found here:
http://www.mrexcel.com/forum/excel-q...ml#post3307823

It has helper columns on your Summary Sheet.. you can hide them if you like..

Please Login or Register  to view this content.

Please Login or Register  to view this content.

it works, thanks !!

2 small issues left:

1. I need to have both of the bottons ("Go" and "Clear") on another sheet ("Main sheet"), i've tried to copy/past and even cut\past - unsuccessfully.
2. when activating the buttons, it automatically open the sheet named "summary sheet", when basically i need it to remain on the same sheet where the buttons
will be located ("Main sheet").

Adding the full file for review.

Thanks again !

Elia.

Thanks !

Hi..

Here is your file back with those changes..

Having said that.. you should use Jindons code.. it is much faster.

Excelent,

Thanks a lot !