Okay I tried using the formula and I am still having issues. In the formula it uses the E collumn but I am lost on that.

I uploaded a sample of the data I am using but the acutal one goes down to 778,112 rows which is too large to upload.

One of things I change when I use your formula is is changing the value 6(assuming that's where the end of checking is) to 778,112 and that's it. online example.xlsx
s