Here's a pretty easy way of doing it, assume the values are in A1:A100 with
a header in A1, sel;ect A1:A100, do datafileradvanced filter, select copy
to another location and where you want the filtered range, select unique
records only and click OK. This will give you a distinct list with the text
values, assume you put them in H1, in the first adjacent cell (in my example
I2) put

=COUNTIF($A$2:$A$100,H2)

copy down as long as needed, now select both columns (H and I) and sort
descending by column I, the first 10 values in H will be the top 10


--

Regards,

Peo Sjoblom






--

Regards,

Peo Sjoblom


"KarenH" wrote in message
...
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.