A doosy- Complex logic for filtering - Can you figure it out?

it's less than 3Mb

3 Mb is not handy here.
I have reduced your file size to approximately 120 KB. That is handy, and can be uploaded here without zipping.
For some reason your file had a lot of empty rows that somehow took up a lot of space.

Here is an uploaded file with the adjusted formula, which I think works well.
If results are different than expected, I would like to hear about it.