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...
You will have to use the same formula for each column seperately.
And there is no difference between +index or index
And there is no difference between +index or index
DevendraJain 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.
