Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
(Using Excel2003/WinXP) I am trying to count the number of times 2 values
are in a cell. The string may contain the values ",abcd, abcf," or ",abcf, abcd," The other part that's stumping me is the string could be ",abcd, abcf, abcg," (or longer). I am wanting to know the number of times the cell contains "abcd" and "abcf" no matter what order it's in. I will try to show an example below: Values 1,abcd, 2 ,abcd, abcf, 3 ,abcd, abcf, abcg, 4 ,abcd, abcg, 5 ,abcf, abcd, I would want to include cell 2, cell 3, and cell 5 in my count, but not 1 or 4. Can I do this? Any help greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
How can I count the # of times the word "Yes" appears in a range | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |