Count number of occurrence in column and print to array

I have two columns. First column contains a sorted list of years and the second column contains values for that year.
E.G.
Column B Column C
2001 27-330
2002 27-330
2003 27-330
2003 27-230
2003 27-230
2003 27-330
2003 27-280
2003 27-250
2003 27-230
2003 27-230
2003 27-230
2003 27-230
2003 27-230

I would like to count the number of occurrences in column C based on Column B and print it to an array format.
Been able to set up the header and row names, but now need to fill in the array.

Please help!!

Master Workbook Rev 9.xlsm

'Bump - No response'

Originally Posted by oeldere

With an pivot table.

See the attached file.

I like the pivot table idea. How can one write this into a VBA code to automatically populate the table with dynamic rows?

Originally Posted by Fotis1991

Duplicate post. Sorry.


The same as usual ...forum issues...

...and so on...

I like the code...
How can this be written into VBA so that it can be applied dynamically?

Originally Posted by Fotis1991

Duplicate post. Sorry.


The same as usual ...forum issues...

...and so on...

I like the code...
How can this be written into VBA so that it can be applied dynamically?

Originally Posted by Fotis1991

VBA is not my forte!

Just for fun i recorded a macro, but i can't see any reason to use VBA for this..

That's pretty cool.

Gives me a head start.

Thanks