Counting the repeated text in another sheet

Posted on

QUESTION :

I have to count the repeated text of a cell which is in another sheet.

Like

link

How can I do it?

ANSWER :

This can be done with SUMPRODUCT and SEARCH:

=SUMPRODUCT(--(ISNUMBER(SEARCH(A1,Sheet1!$A$1:$A$10))))

enter image description here

The main problem is that it will pick up mobile twice as the search requires a partial match.

Leave a Reply

Your email address will not be published.