Searching 20k+ lines for certain text

[theover]

Hi Team

I hope someone can assist me. I'm trying to get a vba or function going to search through 20k+ lines (only column A) for results like "Event" or "Event Management" and would like to know how many times it occurs (typically a Work note)

the line of column A looks something like this:
[TABLE="width: 161"]
<tbody>[TR]
[TD="class: xl63, width: 161, align: left"]23-10-2017 15:52:39 - Event Management (Work notes)
Server: Servername01
Date: 23/10/2017
Time: 15:52:30
UID: 623717e5-fc92-4d96-a3e9-c1c4e5d45c0d
Dest: 10.220.6.10
ESM Tool: SCOM2007
Agent Instance: Client32
Agent Class: SCOM2007
State: Error
Source: ESM
Client: Client32
Header: X-CALL
Instance Detail: Failed to Connect to Computer
User Data: The computer Servername01.01.com was not accessible.

[/TD]
[/TR]
</tbody>[/TABLE]


suggestions welcome please? I have been working through some code and even tried countif but not after a hole bunch of modifications on the data. I'm convinced that after the data modifications some of the data disappear as the results are not consistent

thanks in advance
Theover

 

[PatOBrien198]

=COUNTIF(A:A,"*"&"your search phrase"&"*")

 

[theover]

Thanks but comes up with error in this formula =COUNTIF(A:A,"*"&"Event"&"*")

 

[Stiuart_W]

Is your version of Excel before Excel 2007?

 

[Fluff]

Try
=COUNTIF(A:A,"*event*")

 

[PatOBrien198]

Or, if you don't want to change your formula for each new search term, you could keep the quoted asterics and point to a cell for the search term:

=COUNTIF(A:A,"*"& B1 & "*")

 

[theover]

Is your version of Excel before Excel 2007?

Office 2016 Enterprise latest updates

 

[theover]

Try
=COUNTIF(A:A,"*event*")

Still not working, for some reason it does not like the A," in the formula

any other suggestions please?

thank you

 

[theover]

Solved, mistake on my side. had the separator set as ; instead of , thus the formula was incorrect. thanks for the help guys

 

[Fluff]

Glad you got it sorted & thanks for the feedback