How to count the number of repetition of different values in Excel?

Question

I have data set which is for example like this:

axz 
www 
www 
axz 
hhh 
mjk 
www 

And I want to get something like this:

axz 2
www 3
www 3
axz 2
hhh 1
mjk 1
www 3

I know to get that with countif function, but only for a few specific values. Now I have much more values, so It's not practical for me to use countif where I suppose to know every value which occurs.

Answer 1

You say "It's not practical for me to use countif where I suppose to know every value which occurs". But you can also use a cell as criterion.

Assuming that your column A contains the values axz,www,... you could use the formula below to get your count:

=COUNTIF(A:A,A1)

... and then just "pull" the cell down, which will update the criterion automatically.