Count Max Frequency ignoring blanks

[orrp]

Further to this thread:

Nested IF, AND and FREQUENCY array?

I'm using nested IF and Frequency arrays: {=FREQUENCY(IF(F4:F229=1,E4:E229,""),A14:A15)} This finds all the cells in F4:F229 that have value 1, takes their value in E4:E229 and then work out those values are distributed, according to the buckets in A14:A15. This works great, it's a variant of...

www.mrexcel.com

I am trying to write a formula that returns maximum frequency of non blank lines and not "W"s in column B of the array shown here:

MaxFrequency

Sheet1 Frequency,<a href="https://exceljet.net/formula/longest-winning-streak">https://exceljet.net/formula/longest-winning-streak</a> ID,Result,MaxFrequencyOneIf,MaxFrequencyMultipleIfs 1,w,4,3,Result = B3:B18 2,l,ID = A3:A18 3,l 4,w 5,w 6,w 7,l 8 9 10,l 11,w 12,w 13,w 14,w 15,l 16,w Correct,In...

docs.google.com

This formula returns max consecutive non-W recurrences in the array:
=ArrayFormula(MAX(FREQUENCY(if(Result<>"w", ID), if(Result<>"w", 0, ID))))

And I was hoping this formula would return max consecutive non-W (<>="W") and non-blanks (<>=""), but for some reason, it doesn't return the required input:
=ArrayFormula(MAX(FREQUENCY(if(Result<>"w", if(Result<>"", ID)), if(Result<>"w", if(Result<>"", 0, ID)))))

I know I can simplify this by searching for "L"s, however, I am dealing with much more complicated arrays that have multiple values and blank lines.

Thanks a lot in advanced.

 

[Fluff]

Duplicate to: Count Max Frequency ignoring blanks

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.