I have come to this weird issue where excel isn't using the target cells for my formula until i double click into each cell that that kind of refreshes it into working.
in the example below you can see rows 9,10 and 11 have nothing in column K, however if i were to double click into one of...