| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the number of occurrence within string?
try this
put this formula in C1 =SUM((MID(A1,COLUMN(1:1),1)=B1)*1) use ctrl + shift + enter On Oct 12, 12:17*pm, Eric wrote: Does anyone have any suggestions on how to count the number of occurrence within string? For example, aa11bb5c in cell A1, and "a" in cell B1, I would like to count the number of occurrence for the char "a" in cell B1 within string "aa11bb5c" in cell A1, and return the number of occurrence 2 in cell c1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find SECOND occurrence in a string? | Excel Worksheet Functions | |||
| Most common occurrence of a string | Excel Worksheet Functions | |||
| count number of letters in a string | Excel Worksheet Functions | |||
| How to count the number of times a string appears in a column? | Excel Worksheet Functions | |||
| count number of occurences within a string | Excel Worksheet Functions | |||
Hybrid Mode
