Forum Discussion
How to Look for the Most Occurring Word in a 5x10 Table
DevendraJain I have attached the file. If you look at the file on the Data page, look for the Genres columns, I would like to have a single cell formula to find the most occurring word in that section of the data.
KuroShiiro21 You can find the most common word in each column using this formula
=+INDEX(K3:K16,MODE.SNGL(MATCH(K3:K16,K3:K16,0)))
Try this and let me know is it is working for Genres 1st column
DevendraJain Yes, it works for the first column of genres. As I will be using all 3 columns for the data, do I just insert the other columns in or?
Secondly, is there is difference between INDEX and +INDEX or it works like an addition function.
Thank you.
- You will have to use the same formula for each column seperately.
And there is no difference between +index or indexDevendraJain I have tried to enter all 3 columns into the formula. However as I have blanks in some of the column, the formula ended up not working. Is there a way to edit the formula so as to ignore the blanks?
Thank you.
