Max consectutive values in a block of columns and rows

Hello again

I have a range of data which is 9 columns wide with rows which keep getting added to. I need a function that will report the most consecutive occurences of a particular value. There are only two values in the data entry A or B, but the consecutive nature of the values runs accross the rows. Also, the data may be blank which should just be ignored.

So for example:

A A A B B A
A A B A B B A A A
A A A B A A B
A B B B B A A B A

The answer should report A=6 and B=4

Thanks again

Craig