Previous Topic Next Topic

Help with excel formula

Closed
sk - Oct 1, 2009 at 12:47 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 1, 2009 at 09:22 PM
Hello,

I have to count the number of times the word "work" appears in column A. Column A is a full sentence column with the word "work" appearing only once in the sentence. Also, I just want to count the word when the acronym TPI appears in column F. Any help is greatly appreciated.
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 1, 2009 at 09:22 PM
try this macro (modify to suit you) 

Sub test()
Dim j As Integer, r As Range, c As Range
Worksheets("sheet1").Activate
Set r = Range(Range("A1"), Range("A1").End(xlDown))
j = 0
For Each c In r
If InStr(1, c, "work", 1) > 0 Then j = j + 1
Next c
MsgBox "the number of times the word work appears is " & " " & j
End Sub
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response