Need to count max consecutive string of two values in a ROW

Hello.

I have a row such as this:

Yes No Yes Yes Maybe Yes No No Yes Maybe No

I need to count the longest consecutive string of both Yes & Maybe. So for my example the answer is 4 (Yes Yes Maybe Yes).


Here is another example using letters:

A B C B B A B C A A C A

How would I get the max consecutive string of A & C. The answer in this example is 5 (C A A C A).

Need the formula or array.

Any help is greatly appreciated!

=MAX(FREQUENCY(IF(A1:A12={"Yes","Maybe"},ROW(A1:A12)),IF(A1:A12="No",ROW(A1:A12))))

Ctrl+Shift+Enter, not just Enter

Thank you teethless mama. Seems to be working good. Thanks again.

Okay, the formula is working when data runs up and down one column, however it is not working for a row. I tried changing the ROW in the formula (both of them) to COLUMN. I also made sure to change the range input to A1:L1. When I Ctrl+Shift+Enter the array, it gives me Error or Value prompt. Any ideas what's wrong?

Anyone have a solution to this? I need it to count the length of a streak that includes two different values in a ROW (not a COLUMN). See opening post for examples.

Try this:

=MAX(FREQUENCY(IF(A1:K1={"Yes";"Maybe"},COLUMN(A1:K1)),IF(A1:K1="No",COLUMN(A1:K1))))

Ctrl+Shift+Enter, not just Enter