yogi_Count of Case Sensitive And Non-Case Sensitive Key-Words In Cell A1

Google Spreadsheet   Post  #2308

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-02-2017

question by: appah

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/RJ8D5GyKKwE;context-place=forum/docs

Case sensitive count of occurences in a cell

 

Hi Everyone

I am trying to create a keyword density checker in my sheet, but i'm having problems getting the formula to ignore cases..

I've currently been using this formula:

=(LEN(text)-LEN(SUBSTITUTE(text,word,"")))/LEN(word)

It does the trick but only for exact, case sensitive matches..

This is an example where the text is the blue cell and the text to find the frequencies for are in the green cells: https://docs.google.com/spreadsheets/d/1asP1NHI-UqW0Xu7LxOGY0CCFi6_agfw1u0fAJmhWFPY/edit?usp=sharing

Can any of you help?

Thanks.