I know this has probably been discussed many times...but I need some
help counting rainfall data.

My spreadsheet consists of 50,000+ days worth of rainfall data and I
need to know the maximum number of consecutive days with no rainfall OR
trace rainfall.

For example...my data looks like this from left to right...

0.00 0.00 T 0.15 T T 0.00 0.00 0.27

In this case it would be 4 (T,T,0,0)
Can anyone help?? Thanks in advance...