It seems simple enough but I'm having problems with it.
It's easy enough to use the FIND(text,within,start) command to find some text within one cell, but it won't let me use a range of cells for the 'within' part.
I want a command to check whether a text string is located in either or both of two specified cells.
Cheers
Use COUNTIF
=COUNTIF(range,"*"&<cell ref containing string>&"*")
edit:
You mention FIND in your OP so it's possible (probable) that you're looking for a case sensitive solution and COUNTIF is not viable if that is indeed the case.
=SUMPRODUCT(--ISNUMBER(FIND(<cell ref containing string>,range)))
Last edited by DonkeyOte; 08-13-2010 at 03:09 AM.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks