Formula to count unspecified word/phrase
Hi,
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!
Margherita
Answers
-
Hi,
"But what I would like to get is a formula that recognized instances where the same word/phrase is repeated in different cells".
How is this different from COUNTIF?
-
You can use COUNT(DISTINCT( to find out how many individual names are in that column, without knowing what those names are:
However it sounds like you want each individual name to be counted, without knowing what that name is. In this instance, could add in a helper column in your source sheet to Count how many times the value to the left appears in the column:
Or I would suggest setting up a Report, then Grouping by the Customer name and applying a Summary to COUNT how many rows are associated with each value. See: Redesigned Reports with Grouping and Summary Functions
If none of this has helped, it would be useful to know a bit more about your process.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!