LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Count multiple specific terms

Hi,

I am looking to run a count (or similar) function to find cells that contain two words that are not immediately following.

E.g.
Cell B2: "this cell contains text"
Cell B3: "this cell contains no text"
Cell B4: "this table contains no text"

Count (how many times "no" and "cell" appear in the same cell). =1

Can anybody advise such a function?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Instr() with multiple search terms ExcelMonkey Excel Programming 4 September 23rd 09 11:08 AM
Count across multiple columns, using specific criteria MMcQ Excel Discussion (Misc queries) 9 August 27th 09 05:43 AM
How can I count specific words found across multiple spreadsheets. dutton.dn Excel Worksheet Functions 3 January 3rd 08 06:49 AM
Vlookup multiple terms and return one value sahafi Excel Worksheet Functions 5 June 21st 06 09:11 PM
Count Specific word in Specific range [email protected] Excel Programming 1 May 16th 06 10:55 AM


All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"