Excel - Stack Data based in Condition

Question

I want to stack a table based on this condition

I want to automatically stack every instance of "Available" on the table that is running for at least 4 minutes (screenshot above)

This is a reference to the table.

Only this 8-minute running should appear on the stacking table as there is currently only 1 "Available" running greater than 4 minutes out of 3 "Available" who did not meet the criterion (on the 1st screenshot)

I hope I made my points clear.

Only 1 result can be displayed because I can only use MAXIF based on the table's "Available" requirement.

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.

Answer 1

Try 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. I hope this helps you.