<div>
Use COUNTIF.<br />
<br />
For example:<br />
<br />
=COUNTIF(A1:A100,&quot;mattress<wbr />&quot;) to see how many cells have ONLY the word &quot;mattress&quot; as their values<br />
<br />
=COUNTIF(A1:A100,&quot;*mattres<wbr />s*&quot;) to see how many cells have the word &quot;mattress&quot; within their values, as well as potentially some other text
</div>


Use COUNTIF.

For example:

=COUNTIF(A1:A100,"mattress") to see how many cells have ONLY the word "mattress" as their values

=COUNTIF(A1:A100,"*mattress*") to see how many cells have the word "mattress" within their values, as well as potentially some other text

<div>
Thank you. I have used =if(iserror(SEARCH(&quot;mattre<wbr />ss&quot;,A1)),&quot;<wbr />No&quot;,&quot;Yes&quot;)<wbr />. <br />
<br />
This is a spreadsheet a colleague has created and he wants to enter 1 or 0 for each matched instance. I have amended the formula to do this.<br />
<br />
Very prompt!<br />
<br />
Regards<br />
<br />
Chris
</div>


Thank you. I have used =if(iserror(SEARCH("mattress",A1)),"No","Yes").

This is a spreadsheet a colleague has created and he wants to enter 1 or 0 for each matched instance. I have amended the formula to do this.

Very prompt!

Regards

Chris

<div>
COUNTIF does the exact same thing, without having to resort to an array formula. &nbsp;Did you even try it?
</div>


COUNTIF does the exact same thing, without having to resort to an array formula.  Did you even try it?

<div>
^ Best solution (COUNTIF). &nbsp;No helper column needed; inserts the total in one cell; ultimately faster than having several thousand individual formulas returning 1 or 0.
</div>


^ Best solution (COUNTIF).  No helper column needed; inserts the total in one cell; ultimately faster than having several thousand individual formulas returning 1 or 0.

<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
I have three thousand rows. In one column there is a field that in some instances contains the word &quot;mattress&quot;. I want to see how many instances there are.
</div>
</div>


I have three thousand rows. In one column there is a field that in some instances contains the word "mattress". I want to see how many instances there are.

Is there a LIKE function in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.