| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Top 5 recurring text values with count
My data:
Col 1 Apples Oranges Oranges Bananas Apples I'm trying have excel show the text "Apples" in one col & the count "2" in another col; same with oranges and bananas. I don't know if it is the blank cell that is causing errors but I have tried LARGE, VLOOKUP, MATCH and am not having any luck. Thank you in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count all text values except a certain one | Excel Worksheet Functions | |||
| Count Duplicates in text values | Excel Worksheet Functions | |||
| Conditional Formatting of numbers, but not text, in recurring rows | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Count how many different text values in an array. | Excel Worksheet Functions | |||
Threaded Mode
