LinkBack URL
About LinkBacks
If you put a comma manually at the end of each of the strings, then the simple formula given first should always work, else the array formula given second should do the trick.
If you put a comma manually at the end of each of the strings, then the simple formula given first should always work, else the array formula given second should do the trick.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
JB...you can avoid the CSE with this regular formula variation:
Formula:
=SUMPRODUCT(--ISNUMBER(SEARCH(" 7,"," "&L105:L120&",")))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks