Consecutive Counting - Please Help

Suppose there is a coloumn that has the following data:

A
True
True
False
True
True
True
False
False
False

I wish to count the largest number of consecutive times the word true appears. In the above example the largest would be 3 (Item 4, 5, 6). I tried to use and adapt formulas but can't seem to reach the solution. I can convert True to 1 and False to 0 if the formula requires values rather than text to work out.

Can anyone please help me out?

Regards,
Darren

Hi Darren this thread is similar to what you require.

http://www.excelforum.com/excel-form...-and-rows.html