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.
Configuration: Windows XP Internet Explorer 6.0
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 |
Add 1 in excel Change date range excel 2007 Count and sum unique records in excel Deduct value in excel if cell is colored Excel 2007 change row color based on value Excel 2007 formula invalid reference pop up Excel cell matching Excel converting numbers to integers Excel find date and return text after until next date Excel function string compare Excel spreadsheet password macro Keyboard wont work in excel Macro to copy login user name in excel cell Ms excel compare 2 worksheets Popup box in vba excel Read excel row using visual basic 2008 Start days in excel Vlookup excel two categories