View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default most often values of a column

if your data is in A in a helper column in row 1
enter
=if(counta(A$1:A11,0,Counta(A:A,A1))
copy to the end of your data
then use auto filter on your helper column to select the top 10
"Tamas Konczer" wrote:

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

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