View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KarenH
 
Posts: n/a
Default Top 10 Text Values

I have a column of text values in which I need to display the ten most
frequently occurring. I tried setting the AutoFilter and choosing "Top 10",
but it doesn't seem to be doing anything. I checked into some functions that
I thought might work, like Frequency and Rank, but those seem to be for
numbers only. Is there a way I can accomplish this? Thanks.