Extracting Names from a list based on time ranges

[Cambosity100]

Hi all !

     I know this should be simple but once again I find myself pipped at the post. I have 2 tasks. From a list extract names that fall within a set time frame. The 2nd to extract names that do not enter this time frame. I have got the first formula to work but the second eludes me. Both halves of the 2nd formula work individually but combining them has me stumped. Have tried OR, AND, * (which worked for the first one) Any help greatly appreciated :)

     Please find sample attached. All sample data is fictional.

    As always gratitude in advance :)

[#2 · Accepted solution]

@Cambosity100 

=FILTER(B3:B12,(D3:D12<=B16)+(C16<=C3:C12))

This works in my sheet.

[#3]

Thankyou..... I knew it was something simple I was overlooking. Its Perfect.... :) Exactly what I was looking for... Cheers and Happy Halloween :)

[#4]

@Cambosity100 

Thank you Its exactly what I was looking for. 

        Kindest regards :)