I have strings of different length like the one below:
From this string, I'd like to extract the maximum number of consecutive occurrence of
L. Here it would return
5 because the max is the one in bold.
I was able to come with a formula I have to put on every row (where A2 is the string and B2 is the character,
L in the example):
But I am looking for a unique
=ArrayFormula() formula to avoid replicating this formula on every rows.
You'll find an example to play with following the link below: