Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a cell that contains....
"2 red hat, 1 green glove, 2 red glove, 2 yellow hat" What I need to be able to do is; count the number of items containing "2 red" and return the value 4. And; count the number of items containing "2 yellow" and return the value 2. I've tried using COUNTIF, FIND, SEARCH, etc. and can't come up with a way to do it. Thank you in advance for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
counting occurances | New Users to Excel | |||
Counting 7 and 8 occurances | Excel Discussion (Misc queries) | |||
Counting occurances | Excel Discussion (Misc queries) | |||
Counting Occurances | Excel Discussion (Misc queries) | |||
counting occurances | Excel Worksheet Functions |