Max function Based on previous entries criteria pattern till current row

Hi,
I want to use max function for variable range.
Starting row will be based on pattern in Col A and ending row will be current row..
I have used max if with not correct result and also indirect function for row reference.. i am going wrong..
want a macro or formula..
attaching file yellow is the result needed

see attachment. is it what you need?

Hi gue,
Your solution is eventhough has the same result..
But what i want is the first column is the pattern.. for each pattern i am checking non zero minimum value, so that is maximum formula from starting row of the pattern( here the pattern is 1-2-3-4),
So starting row of 1 till the current row , max function..
In that process, i am finding minumum non zero value for that pattern greater than a variable in H1 , which i have not provided...lets say 1..

So , i am trying to find max values for that particular pattern range..
Then i will check whether it is greater than variable or not..
If it is greater , i will have the number else it will be blank.
Finally for each pattern i will have a value as summary..

This is what i am trying to achieve.

For pattern 1 the max function should have for current row 5
max(b1:b5)
for pattern 2 current row 10
max(b6:b10)

I am having around 80000 rows, so am trying for macro..
But essentially it is a max if with starting row and current row is variable range..
So formula is also appreciated..

yes.. but the starting row for the range must be based on col A pattern (1-2-3-4)..
Till the active cell..
Will check your code..

Hi,
No your code doesnt produce desired result.. not based on active cell..
max range or max if range starting and ending range- starting - based on col a pattern starting row.. ending range is current row
i did like this
=+MAX("Q"&N3&","&"Q"&Q21&"")
or
/{=MAX(IF("B"&N5&":"&"B"&N5&""=B5,"h"&Q5&":"&"h"&Q5&""))}
But it is either showing #value error or 0..

Hi Sintex,
COl A is the pattern.. if you see 1-1-1-1,2-2-2-2
so it changes after a series of repeating value..

I want to summarize value for each pattern..
Condition non zero values
>5
minimum value among the pattern group..

So lets say.. for pattern 2.. the answer would be 6..
it is non zero, greater than 5 and minimum value among that group..

so for 2 it would be 6
for 1 there is none
3 also 6
4 it is 8

This is what i am trying to summarize

The said pattern is no of days.. so for each day i am logging values and trying to summarize not based on sum.. but based on minimum of that day provided it is greater than the condition (> somevalue in the example it is 5)

And i have too many rows approx 80K so it would be difficult for me to change the range for each.. so formula or macro i need...

Macro would be prefered as my above formula is giving me #value and due of no of rows..