How can i count a continuous text in a data series...

[amit_k21000]

Guyz ...Lets say i have a data in 50 fields...The data is only in form of TRUE and FALSE

Now , in next field i want as an output that say "YES" if there is a continuous occurrence of TRUE for 9 cells or more.

Ex:

FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> </tbody>

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[amit_k21000]

Thanks guyz..I have managed to sort it out by myself with a simple formula..... Thanks all of you for your help....