| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula to count the number of records which contains a certaintext (wildcard)
Hello,
If you want to count the number of records which contains a certain text you can use in excel the formula =COUNTIF(C:C;"aaa") Which formula can I use if I want to count the number of records which contains 'aaa' within the cells. For example C1= aaa C2= bbb C3= aaaccc C4 = kkkaaabbb The number of records which contain the text 'aaa' in this example is 3. If you see I want to use something like a wildcard in a formula. regards, Johan. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula should I use to count a number of records? | New Users to Excel | |||
| Excel - count the number of records between two specific dates. | Excel Worksheet Functions | |||
| Count the number of AutoFiltered records | Excel Worksheet Functions | |||
| Count Number of Records and Number of Fields in CSV File | Excel Programming | |||
| Count the number of unique records | Excel Worksheet Functions | |||
Threaded Mode
