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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!