Looking for a Function which counts the repeatition of text in a column

  • Thread starter Thread starter shirish
  • Start date Start date
S

shirish

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
 
Try...

=COUNTIF(A1:A10,"*loans*")

or

=COUNTIF(A1:A10,"*"&B1&"*")

....where B1 contains the criteria, such as 'loans'.

Hope this helps!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First row where a cell is zero 1
How do I create the formula for this calculation? 1
Count the number of AutoFiltered records 6
Building closed workbook file path within an Index Function 6
count unique values in one column for a set value in another col. 2
Counting Results of Formulas 1
Counting the number of times a character occurs in a cell 1
Using a Range to find text 7

Back
Top