certain words "CONTAINS" in an free text cell...........

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Everyone has been so much help. I've got one more question -- and I'm not
going to promise you it will be my last. :)

I have a free text comment cell that I need to search for certain words.

=SUMPRODUCT(--('Survey Data'!C2:C500="Bell"),--('Survey
Data'!J2:J500"contains the words optional exam"))

I need to put in the code that will search for the words "optional exam"
within a free text cell.

Any help would be gladly appreciated.
 
=sumproduct(--('Survey Data'!C2:C500="Bell"),
--isnumber(search("optional exam",'Survey Data'!J2:J500)))

If you want it to be case sensitive, use Find instead of Search.
 
Does it only contain "optional exam"? Or does it contain those words, along
with other words?


=SEARCH("optinal exam",A1) will return 1 if the words "optional exam" are in
A1.

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel If a Cell Contains a Certain Text (From Another Table) 0
Help! Text word search. 3
Count cells containing specific text 4
Delete cells containing specific data? 1
Formatting cells containing certain words 1
Search for reference in an array 4
Count Cells where text may contain a specific word 5
Text in Cell Formatting 5

Back
Top