Hi
I've read a few posts and dicussions but still can't seem to find an answer that I can use.
I'm collecting data and have some basic dashboards setup which display the number specific words are recorded.
As an example:
Clinical
Clinical Lead
Clinical Specialist Lead
Operational Lead
I need to be able to count how many 'Clinical' roles I have (the number returned should be 3). The key word is Clinical.
I'm looking for some sort of 'where' or 'contains' formula that I use with COUNTIF
Kind regards
Phil