title: How to compute the maximum series of a specific condition returning true
body: <p>i have a slight issue to count the MAX frequency of where the third colmn is bigger than the second. This is just a statistic with scores. 
  The issue is that i want to have it in one single formula without a macro.</p>
  
  <pre><code>B   C
  ------
  2   0
  1   2
  2   1
  2   3
  0   1
  1   2
  0   1
  3   3
  0   2
  0   2
  </code></pre>
  
  <p>i have tried it with:</p>
  
  <pre><code>{=MAX(FREQUENCY(B3:B100;B3:B100&gt;=C3:C100))} to get 1 for B
  {=MAX(FREQUENCY(C3:C100;C3:C100&gt;=B3:B100))} to get 7 for C
  </code></pre>
  
  <p>I excpected it to deliver me the longest series where the value in the one column was bigger than in the other one, but i failed hard...</p>