I want to stack a table based on this condition

I want to automatically stack all count of "Available" that is running minimum 4minutes and up on the table (screenshot above)

Here is the table reference

So far, there are only 1 "Available" running more than 4 minutes out of 3 "Available" who did not met the criteria, so only this 8mins running should show on the stacked table (on the 1st screenshot)

I hope my explanations are clear.

I can only do MAXIF based on the criteria "Available" on the table so only 1 result can be shown.

I want all "Available" that has running 4minutes and up to be listed and stacked on the table automatically and it should show blank if everyone is below 4 minutes.

CodePudding user response：

I think you are looking for something like this:

=TEXT(SORT(FILTER(B:B,(B:B>=TIMEVALUE("00:04:00"))*(A:A="Available"),""),1,1),"h:mm:ss")

It appears you tried Filter but you should not need to change anything as it is dynamic.

EXPLANATION:

You are filtering column B where the time value is greater than 4 mins and the corresponding value in column A is "Available". Then you are simply converting the excel format of TIME into a readable time value.