most often occurent value(s)

[Tamas Konczer]

I would like to count and determine the most often (10) occurent
values (strings) in a column.

How can I do that?
Thank you very much your help.

 

[Bernie Deitrick]

Tamas,

Use a helper column of formulas. For example, in cell B2:

=IF(COUNTIF($A$1:A2,A2)=1,COUNTIF(A:A,A2),"")

Copy down to match your column, then use Data / Filter.. Autofilter and pick "Top 10" from the
dropdown at the top of column B.

HTH,
Bernie
MS Excel MVP

 

[jan]

Tamas

A pivot-table can do the job for you.

Jan