Excelina1234
New Member
- Joined
- Nov 10, 2014
- Messages
- 23
Hi All,
I'm trying to find the top 3 most frequently used *words* in a column on my spreadsheet.
Although I can easily find the #1 most frequent word, Top 1, (using Index, Mode, Match), I am stuck when it comes to the top 2 and top 3.
The idea is that I want the formulas for Top 2 and Top 3 to be similar to the "Index, Mode, Match" I am using for Top 1 in the sense that all that they require is one cell with the formula to calculate the results for the chosen range.
For your reference, here is the formula I am using for Top 1:
=INDEX(A1:A10,MODE(MATCH(A1:A10,A1:A10,0)))
Thank you for your help!
I'm trying to find the top 3 most frequently used *words* in a column on my spreadsheet.
Although I can easily find the #1 most frequent word, Top 1, (using Index, Mode, Match), I am stuck when it comes to the top 2 and top 3.
The idea is that I want the formulas for Top 2 and Top 3 to be similar to the "Index, Mode, Match" I am using for Top 1 in the sense that all that they require is one cell with the formula to calculate the results for the chosen range.
For your reference, here is the formula I am using for Top 1:
=INDEX(A1:A10,MODE(MATCH(A1:A10,A1:A10,0)))
Thank you for your help!