| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Top 5 recurring text values with count
On May 5, 3:07*pm, S wrote:
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 Perhaps provide sample data and results expected. =COUNTIF($B$16:$B$21,B16) Will count the number of apples/bananas in the range,but you get multiples. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Top 5 recurring text values with count
Works perfectly! I was over-complicating things. Thank you so very, very
much! "מיכאל (מיקי) אבידן" wrote: You will be better off by using a 'PivotTable'. Micky "S" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
