View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PeterM PeterM is offline
external usenet poster
 
Posts: 19
Default Counting Occurances (2003)

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!