Frequency of Unique Values in a cloumn

[BetaDocuments]

I have over 200 values in a column, some of them are repeats. Need to
find out how many times each value is present. Thanks in advance!

 

[BetaDocuments]

I have over 200 values in a column, some of them are repeats.  Need to
find out how many times each value is present.  Thanks in advance!

just thought about using Pivot Table. Got my answer! Thanks everyone!

 

[Rich]

I have over 200 values in a column, some of them are repeats. Need to
find out how many times each value is present. Thanks in advance!

in another column, apply the formula (where a:a is the column containing
the 200 values, and a1 is the cell containing the first value. copy
formala down to a cell in the same row as the last value.)
=countif(a:a,a1)