RedditPP Mascot

RedditPP

r/googlesheets • … • u/Affectionate_Wish557

Filter if column contains text

Hi,

is there any way i can change this formula that says "this range is equal to b5" to say "this range contains text from b5"

=FILTER(Booked!A2:J ; Booked!H2:H = B5)

Just to mention, "H" column in "Booked" sheet is formated to date (dd.mm.yyy. hh:mm:ss)

And i want to type just date in b5 to filter it :)

Thanks in advance.

— 0