Forum Discussion

Cambosity100's avatar
Cambosity100
Brass Contributor
Oct 31, 2021
Solved

Extracting Names from a list based on time ranges

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...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Oct 31, 2021

    Cambosity100 

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

    This works in my sheet.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Oct 31, 2021

Cambosity100 

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

This works in my sheet.

  • Cambosity100's avatar
    Cambosity100
    Brass Contributor
    Oct 31, 2021
    Thankyou..... I knew it was something simple I was overlooking. Its Perfect.... 🙂 Exactly what I was looking for... Cheers and Happy Halloween 🙂