Hi Group,

I am looking for a function which will count occurence of part of text
in a cell in one column.

For example cell contains My finance loans and the columns conatins
many combination of loans I want to count how many times the "loans"
string occurs

Note: Without using data filter option.

Thanks
Shirish