title: Lookup most used text in range based on criteria
body: <p>I have the following CSE formula to return the most used text in a range,excluding empty cells. </p>
  
  <pre><code>=INDEX(A4:D4,MODE(IF(A4:D4&lt;&gt;"",MATCH(A4:D4,A4:D4,0))))
  </code></pre>
  
  <p>My problem is that the formula returns #NA when there is only one value in the range. How can I adjust the formula to return that value?</p>