title: MODE IFS in excel - applying criteria to MODE function and excluding a number from the series
body: <p>I am using MODE IF in Excel, which seems to work fine, but I need it to exclude from the MODE all number 2's.</p>
  
  <p>The Formula I am using is as follows:</p>
  
  <pre><code>=IFERROR(MODE(IF($I:$I=I4,$K:$K)),K4)
  </code></pre>
  
  <p>entered with Ctrl+Shift for an array formula.</p>
  
  <p>The IFERROR bit is there for when there is only one occurrence of a number.</p>
  
  <p>Could anyone please tell me how to develop this formula so that, where the result would normally be a "2", that it finds the next highest occurring number instead?</p>
  
  <p>Many thanks
  Rich</p>