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