Subscribe for more free professional tips.

0 Members and 1 Guest are viewing this topic.

gianfrancopierino

  • 50+ posts Member
  • **
  • 93
  • Member
  • Rated: +3
need excel wizard help
Aug 24, 02:59 PM 2021
Hi guys, need help from an excel wizard.
How can i find if 8 consecutive results are repeating in the next 8 extractions?

*

ati

  • 500+ posts Member
  • *****
  • 733
  • Roulette Forum .cc | Lurker
  • Rated: +80
Re: need excel wizard help
Aug 28, 09:08 AM 2021
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.