most often occurent value(s)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tamas Konczer - 14 Mar 2007 12:32 GMT

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.

Reply to this Message

Bernie Deitrick - 14 Mar 2007 15:38 GMT

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

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

Reply to this Message

jan - 14 Mar 2007 18:24 GMT

Tamas

A pivot-table can do the job for you.

Jan

Reply to this Message