Frequency of Unique Values in a cloumn

B

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!
 
B

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!
 
R

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top