title: Excluding one more value from MODE function on Google Spreadsheets
body: <p>For the moment I find myself with a problem in my formula. I have a huge list of numbers in my column A, where I want to know the number that occurs most often (using the mode function). To do so, I also had to exclude 0 as a number.</p>
  
  <pre><code>=ARRAYFORMULA(mode(ifs(A2:A50&lt;&gt;0;A2:A50)))
  </code></pre>
  
  <p>However, I want to know which number occurs most often after the first number. I tried this formula but did not get results, I continued to get the 41 (which is the number that occurs most times in this list).</p>
  
  <pre><code>=ARRAYFORMULA(mode(ifs(A2:A50&lt;&gt;0;A2:A50;A2:A50&lt;&gt;B2;A2:A50)))
  </code></pre>
  
  <p>How can I solve it so that I can ask for a 3rd number that occurs more often?
  Thank you!</p>