1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How Do I Count and Filter for Most Common Text Strings in a Range?

Example Range

I want to find the top six most common strings in a range, while also filtering for blanks. I know that MATCH only works on single columns, how do I write formulas that account for a full range, and finds the top six most common instead of just the most common?

For example, a formula that would find the most common, another that would find the second most, a third that would find the third, etc.

submitted by /u/AMarillOnReddit
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article