I have 100 cells (4 columns by 25 rows) the contents of which are randomly generated to contain either a 1, 2 or 3. The cells are recalculated regularly. I am trying to determine/record the results of the number of times that 3 consecutive 1s, 2s or 3s appear, the number of times that 4 consecutive 1s, 2s or 3s appear....all the way to 20 consecutive appearances of 1s, 2s or 3s--to the extent such a run would be generated. I have tried like to come up with something and nothing seems to work. Also, because the numbers are recalculated, the results need to be tabulated/recorded in another cell before the cells are regenerated. If you can help, I would really appreciate it. Thanks a lot.
CC
CC