Forum Discussion
How to Look for the Most Occurring Word in a 5x10 Table
I am trying to find the most occurring word in Excel in a 5x10 table. After looking through Youtube and other guides available, I have tried to use MATCH,INDEX,MODE. However, after entering the formu...
Can you share the Excel file
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.
