find the longer repetition of 5 from column A

Leonardo1234 · Aug 22, 2018

My data is in column A what I want is to find longer repetition of 5
here in this file longer repetion of 5 is 3 I want that result
see sample file

Belleke · Aug 22, 2018

What about the equal for example 3 times 5 and 3 times 2

Leonardo1234 · Aug 22, 2018

We have to only concentrate on 5

Luke M · Aug 22, 2018

Confirm as an array using Ctrl+Shift+Enter
=MAX(FREQUENCY(IF(A1:A15=5,ROW(A1:A15)),IF(A1:A15=5,0,ROW(A1:A15))))

Belleke · Aug 22, 2018

I have this one (ietsie pietsie different)

also Ctrl+Shift+Enter
=MAX(FREQUENCY(IF(A1:A15=5,ROW(A1:A15)),IF(A1:A15<>5,ROW(A1:A15))))

Leonardo1234 · Aug 22, 2018

Thnx Belleke and Luke M for giving ur precious time and great support to this post
Problem Solved

bosco_yip · Aug 23, 2018

Or, this shorter non-array formula :

=MAX(FREQUENCY(ROW(A1:A15),(A1:A15<>5)*ROW(A1:A15)))-1

Regards
Bosco