Hi, I'm new to excel and been able to figure out most as I go but this one's stumping me..
I need to calculate max number of consecutive positive integers in H:H that also has "long" written in the corresponding E:E.
This is where I'm at currently, but I know it's not right as it's returning #VALUE, or #N/A when I turn it into an array with CTRL SHIFT ENTER
It needs to continue counting until it reaches an E:E that still says "long" but a negative or even integer in H:H, and skip over any rows where E:E isn't "long"
=MAX(FREQUENCY(IFS(E:E="long",H:H, H:H>0,H:H),IF(H:H<=0,H:H)))