Lets say I have 3 columns. column A is a list of numbers 1-10. Column B are conditions such as if A1 & A2 are both <5, then show TRUE. Column C is condition if A1 <5, then show true. I want to find out how many times when A1 & A2 are both <5, the NEXT number that is <5 will also be accompanied by the number below that is <5, meaning once A1 and A2 is <5, eg A1,A2 ,A5,A6 ,A12,A13. So it cannot be A1,A2,A5,A12,A13. I want to count the number of such combos A1,A2 ,A5,A6 ,A12,A13 appearing in my long list of numbers. How can I achieve that? Thanks!