|
» Counting the Number of Times a Specified Substring Appears within a Range of Strings
CATEGORY: Excel Counting |
VERSIONS: All Microsoft Excel Versions |
|
Problem: Counting the total number of times each of the substrings listed in column B appears within any of the strings in column A. Solution: Use the SUMPRODUCT, LEN, and SUBSTITUTE functions as shown in the following formula: =SUMPRODUCT(LEN($A$2:$A$6)- LEN(SUBSTITUTE($A$2:$A$6,B2," ")))/LEN(B2) |
|
RATING:
4.00
VIEWS: 6419 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Keys to Reading an Annual Report (Barron's Business Keys)
- How to Read A Financial Report
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
