how to count total # of time a contact appears in a column when there are multiple names in a cell
How to count total number of times a name (contact) appears in a column when there are multiple contacts in a cell within a column.
I have a name column where there could be multiple contacts listed within a cell. I need to count total number of time each name appeared in the column. What formula or functions would get me my desired result. Here is the screen shot to give an idea of my data and what I want to do with it (i.e. desired state).
Thanks in advance for your inputs!
Help Article Resources
Check out the Formula Handbook template!