Counting Specific Text in Excel 1

[Cordury]

I ran a query and dumped it into Excel. One of the Columns is labeled "Remarks". I want to count all records/rows where a certain word appears in the "Remark Column". Since there is a couple of sentences in each cell, I can not use a straight If or countif formula.

Any ideas?

Thanks,
Cord

 

[SkipVought]

Hi,

The easiest way to get a quick answer is to use the AutoFilter and use Custom with the Contains operator and your string.

Then Select the entire column and right click the bottom right-hand Excel frame and select Count. You count will appear in that little panel.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[dan1967]

You can use CountIf:

=COUNTIF(C2:C56,"*your word or phrase*")

Always remember wildcard characters.


Dan.

 

[Cordury]

Thanks guys, I did not know about the wildcard *.

That is a hot little tip!

Thanks again!

 

[dan1967]

You are welcome. Thank you for the star.

Dan.