Finding the most common text over a range of rows
Hi Smartsheet community! I'm looking for a way to identify the most common text-based errors across a specific range of rows in my sheet.
Here's the situation:
I have a Smartsheet containing columns with text data. The text are errors that my team finds during a quality review.
I want to identify the most frequently occurring text within a defined range of rows (e.g., CR1 - SP27).
Ideally, I would like to:
Find the top 5 most common errors.
See the actual error text, not just the count.
I've considered these options:
COUNTIFS/INDEX/MATCH: I understand these formulas can count occurrences and retrieve values, but I'm unsure how to adapt them for this specific scenario.
What's the best formula or approach to achieve this?
Thank you in advance for your help!
Help Article Resources
Check out the Formula Handbook template!