most often occurent value(s)

T

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

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
 
Top