Formula to count unspecified word/phrase
Could anyone help me in finding a formula able to count how many times unspecified words/phrases come up in a column?
Specifically: I have 1 column of a sheet where I am tracking the name of customers. What I would like to get is a numerical quantification of how many times the same customer is found in one column. So far I have been using the COUNTIFS formula, but this means that I need to state a specific word/phrase in order to count how many times it comes up in a column. But what I would like to get is a formula that recognized instances where the same word/phrase is repeated in different cells.
Thanks a lot!
Help Article Resources
Check out the Formula Handbook template!