detect bigger smaller and equal always from the last draw .

[jorel]

detect bigger smaller and equal always from the last draw to the next
* greater = 2
smaller = 1
* equal = 0
always seeing the position of being one of the three possible patterns, and identifying the largest sequences of 0 or 2 or 1, in the example we have the sequence of 111 ...
https://www.excelforum.com/attachmen...1&d=1589829484

[maras_mak]

Try this solution.

Please Login or Register  to view this content.

[jorel]

hello, maras magnificent, congratulations !! great job
* works well thanks