title: Find x consecutive numbers in an array
body: <p>I have an array of non-ordered integers, and I am trying to return a TRUE or FALSE based on if x consecutive numbers can be found within the array</p>
  <p>Example array in A1:A8 [20,17,13,16,21,22,19,18]</p>
  <p>In B1 is [5], requiring the function to find 5 consecutive numbers.</p>
  <p>No VBAs please</p>
  <p>Based on similar queries and answers on this website, the best I came up with was
  =AND(IF(SUM(--(A1:A8=TRANSPOSE(A1:A8)+1)),TRUE,FALSE),IF(SUM(--(A1:A8=TRANSPOSE(A1:A8)+2)),TRUE,FALSE),IF(SUM(--(A1:A8=TRANSPOSE(A1:A8)+3)),TRUE,FALSE),IF(SUM(--(A1:A8=TRANSPOSE(A1:A8)+4)),TRUE,FALSE))</p>
  <p>I tried to mimic one of the answers from below
  <a href="https://stackoverflow.com/questions/54051141/how-to-determine-if-a-range-of-cells-contain-consecutive-numbers/54052334#54052334">How to determine if a range of cells contain consecutive numbers?</a></p>