How would I create a formula which returns the Top 5 most frequent words in a column?
I have been tasked with creating metrics which show the current 'Top 5' most frequent countries in a column. I am struggling to create a formula which returns the correct value as new countries will be added to the list in future so COUNTIF would not work. So imagine the column read as follows:
The formula would return the following
Help Article Resources
Check out the Formula Handbook template!