VBA fill cells based on other colum

[Datalover]

For a project i want to know how many of a value is in a list, but only for the cells that are shown.
In A i have all the values
In B i have all the uniques

=UNIQUE(A:A)

In C i have the formula

=COUNTIF(A:A;B1)

Now i have to manually drag down this formula for as long B contains values

So if B goes from B1 until B12 i need to fill in c1 to c12
If A gets an extra value, B will extent to b13

Im looking for a way to let a macro see to what cell B is filled and fill the c cells with the formula.

Who can help me search in the right way?

 

[Fluff]

Hi & welcome to MrExcel.
No need for a macro, just use

=COUNTIF(A:A;B1#)

 

[Datalover]

This is exactly what i was looking for. This solution is so elegant, i love it.

 

[Fluff]

You're welcome & thanks for the feedback.