Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to count the occurrence of a string that would be contained in text in a column.
For example, in column J, starting at cell 1, J 1 x1 x4 2 x1 x2 x3 3 x2 x5 4 x3 x4 x6 (For example, cell J1 equals the text string "x1 x4".) So, the answer to the number of times the string ''x4' occurs in J1:J4 is 2. Is it even possible for this type of counting to be performed with an Excel formula? How??? Thanks, -Bill. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to count the number of times a string appears in a column? | Excel Worksheet Functions | |||
Column A = X, Column B =y count = count +1 | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Count cells based on date range in another column | New Users to Excel |