Excel VBA to count and print the occurance of a value from a range of cells

[Vinod Krishna.C]

Dear all,

I would like to have Excel VBA code to count and print the occurance of a value from a range of cells.

Ex: Sheet " Input " has the following data:

No.	Name
1	Albert
1	Albert
2	Boris
2	Boris
2	Boris
3	Chris

I would like the output as follows in the sheet "Output" :

No.	Count
1	2
2	3
3	1

Looks simple but not sure if it's efficient to loop through all values and have a counter variable to store the count or if a built-in function can do this?

I would love to know the VBA code to do this.

Many thanks in advance.

Regards,
Vinod Krishna