I have to count the repeated text of a cell which is in another sheet.
How can I do it?
This can be done with SUMPRODUCT and SEARCH:
The main problem is that it will pick up
mobile twice as the search requires a partial match.