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:

[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: center"][TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: center"]FALSE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="width: 64, align: right"][/TD]
[/TR]
</tbody>[/TABLE]

 

[amit_k21000]

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