Code that Counts number of time string occurs in a column

Hello everyone.

I need a code that search through a column, counts the numer of times a string occurs and creates on another sheet the unique string and the number of times it occured.

e.g

I have this columns in a worksheet

s/n name company trainer
1 ball Dell Mk
2 doll Msed Kl
3 kol Dlink Mk
4 ball Msed Cl
5 Koll Dell Gl

I need the result to appear on another worksheet like this

Name NumberofTraining
Ball 2
doll 1
Koll 2

Thanks Guys

In anticipation of your response

Thanks.. its quite helpful but let me add an attachment so that you will have a perfect understanding of what i want to do.autogra.xlsx

Originally Posted by Glenn Kennedy

Sooooo much easer with a sheet to work on.

Thanks Glenn

But i need a button on the data page (as from the user side this is the only page) and by pressing the button it comes up with the result sheet

Thanks Again

Originally Posted by Glenn Kennedy

I'm really not quite sure what you mean...

instead of using functions on the worksheets, can it be done by using macros such that when the macro is run it gives the result sheet

Hello Glenn

Can the range be increased to 3000 rows instead of the 30 you used.

Thanks in aticipation of your kind help.