title: Most Frequent Word In A Range, Ignoring Blanks
body: <p>I currently use the following formula to find the most common word or number in a range:</p>
  
  <pre><code>=INDEX(E9:E18,MODE(MATCH(E9:E18,E9:E18,0)))
  </code></pre>
  
  <p>However, if there are any blank cells then the formula returns a blank cell as the mode. How can I modify this to find the most common word/number ignoring any blank cells?</p>
  
  <p>Many thanks</p>