Hi guys, need help from an excel wizard.
How can i find if 8 consecutive results are repeating in the next 8 extractions?
There are many ways to do that. Copy this to the B1 cell, then double click on the bottom right corner of the cell to auto fill the rest of the column.
=COUNTIF(A1:A8,A1)=8
After that simply apply a filter and check if you get TRUE values.