title: How do I find out the longest run of a number?
body: <p>This seemed like a trivial question to me, but I cannot get it done correctly. Part of my dataset looks like this</p>
  
  <pre><code>1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 0    
  </code></pre>
  
  <p>and contains two “runs” of 1 (not sure if that’s the correct word), one with a length 3, the other with a length of 5.</p>
  
  <p>How can I use Google Docs or similar spreadsheet applications to find the longest of those runs?</p>