title: How to search for a specific data of consecutive numbers in a column of an excel even if multiple instances are present
body: <p>How can I find multiple instances of presence of consecutive numbers in a column of big data of 1's and 0's in excel spreadsheet.
  For example, my excel column is given below:</p>
  <pre><code>0                    
  0  
  1   
  1   
  0  
  0  
  1  
  0  
  1   
  0  
  0  
  1  
  1   
  0  
  1  
  1  
  1  
  0  
  0  
  1   
  1    
  0    
  0  
  1   
  0
  </code></pre>
  <p>Please assume this as some of my column data, I need to find wherever the sequences of 1's and 0's present in the column.</p>
  <p>I defined a function for finding single instance as below:</p>
  <pre><code>Function FINDSEQ(seq As String, rng as Range) As Long
      FINDSEQ = InStr(1, Join(Application.Transpose(rng.Value), &quot;&quot;), seq)
  End Function
  </code></pre>
  <p>But I couldn't find how to find multiple instances if present.
  For Example, I need to find:</p>
  <pre><code>1    
  1  
  0   
  0   
  1  
  0   
  </code></pre>
  <p>as the sequence of consecutive numbers, what change should I do?<br />
  Here 1 1 0 0 1 0 is present two times, but based on the above defined function I could only find a single instance.</p>