Forum Discussion
Identify the correct function to count instances of text
I am reviewing a list of organisations that have provided information on the area or areas of Scotland in which they operate. This data is extracted from a CRM system and the area or areas of Sc...
With the data in A1:B3 and the area names in D1:D5, enter the following formula in E1:
=SUM(--ISNUMBER(SEARCH(", "&D1&", ",", "&$B$1:$B$3&", ")))If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.
Fill down.