» Calculating the Proportion of Characters from One String that Appears in another String
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: Calculating the percentage of the characters from each string in column B that appear within the corresponding string in column A.
Solution:
Use the SUM, ISNUMBER, FIND, MID, ROW, INDIRECT, and LEN functions as shown in the following Array Formula:
{=SUM(--ISNUMBER(FIND(MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1),A2)))/LEN(B2)}
To apply Array formula:
Select the cell, press
Book Store:
Recommended Books:
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- PowerPoint® 2002 For Dummies®
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Retire Young, Retire Rich
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
No comments have been submitted.
