| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
counting instances of words in a worksheet cell
I would like to be able to count the instances of "apple" in the
following example, where each line is the value in one cell: column 1 x apple apple x x x x apple x to get the answer = 4 instances of apple. How can I do this in excel? any help greatly appreciated CJ |
|
#2
|
|||
|
|||
|
Hi CJ
getting the answer 4 from the given example would be difficult, however, if you'ld settle for 3 then use the following formula =COUNTIF(A1:A4,"*apple*") Cheers JulieD "CJ" wrote in message om... I would like to be able to count the instances of "apple" in the following example, where each line is the value in one cell: column 1 x apple apple x x x x apple x to get the answer = 4 instances of apple. How can I do this in excel? any help greatly appreciated CJ |
|
#3
|
|||
|
|||
|
The word apple is always on a cell by itself?
=COUNTIF(your_range,"apple") If it isn't, then try: =COUNTIF(your_range,"*"&"apple"&"*") TJ "CJ" wrote: I would like to be able to count the instances of "apple" in the following example, where each line is the value in one cell: column 1 x apple apple x x x x apple x to get the answer = 4 instances of apple. How can I do this in excel? any help greatly appreciated CJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| how to change or set the last cell on a worksheet | Excel Discussion (Misc queries) | |||
| Excel, how to reset the "last used cell on the worksheet " | Excel Discussion (Misc queries) | |||
| Counting instances in a cell | Excel Discussion (Misc queries) | |||
| How can I activate cell shading in a protected worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
