| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting two cell values into a new cell + text | Excel Discussion (Misc queries) | |||
| How do I LOOKUP text values | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| how do i detect like text and add corresponding values? | Excel Discussion (Misc queries) | |||
| text and values combined in one cel | Excel Discussion (Misc queries) | |||
Threaded Mode
