title: EXCEL finding consecutive duplicate rows in excel
body: <p>in excel one column contains like below
  1
  2
  5
  6
  1
  2
  5
  6
  3
  4</p>
  
  <h2>Now i want to find out consecutive 1 2 coming 2 times. 5,6 coming 2 times. 3,4 coming 1 time. Please let me know how this can be achieve.</h2>
  
  <p>similarly consecutive 3 duplicates.
  1
  2
  3
  7
  8
  9
  1
  2
  3
  7
  8
  9
  3
  4
  5</p>
  
  <p>Now i want to find out consecutive 1 2 3 coming 2 times. 5,6 coming 2 times. 3,4 coming 1 time. Please let me know how this can be achieve.</p>