filter with blanks

[dmheller]

I have data like this.
it is a table.
I want to filter out a date or month or anything but when i do, it leave out the blanks. So if i filter date 1/3/24 i get only row 12.
Is there a way i can filer 1/3/24 and get row 12-16 without putting 1/3/24 in each row?

 

[hagia_sofia]

Hello, try:

=LET(
date,A5:A33,
description,B5:B33,
a,SCAN("",date,LAMBDA(a,b,IF(b<>"",b,a))),
FILTER(description,(a=DATE(2024,3,1))*(description<>""),""))

And you might wanna replace DATE(2024,3,1) by a cell reference with the date you are interested in...