see response in .misc

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Trapper via OfficeKB.com" wrote in message
...
Thanks for the quick response! It is almost what I need, i think it's the
right formula but the result was not quite what I was expecting. I am
thinking a different approacch would help. What formula would I use to
just tell me how many times either O or U, whichever I choose, occurs
consecutively. I.E. how many time does O appear 2 times in a row, or 3
times in a row, or 4 times in a row.