I have used various formulas on this site to count consecutive occurences
fora piece of data, but to no avail. Can someone please help? In column
"I" I have a bunch of O's and U's. I want to be able to count how many
times O appreared 3 consecutive times, 4 consecutive times etc.. up to 10.
My column run down to 162 on some pages and less on others, if this matters?
Also is there a way to do a check based on a hiearchy of variables?

--
Message posted via http://www.officekb.com