Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Occurances (2003)
hi can you please put int in grid format so that i can figure it out what you want? "PeterM" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Occurances (2003)
Hi. Here is one way. The 2 is the value, and the 5 is the length of "2
Red" For "2 Yellow", you would use 2/8 (or 1/4) =(2/5)*(LEN(A1)-LEN(SUBSTITUTE(A1,"2 red",""))) = = = = = = = = = = HTH :) Dana DeLouis On 1/3/10 12:49 AM, PeterM wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |