Hi,
I have this formula:
Formula:
=FILTER(Movie_Data,(ISNUMBER(SEARCH(B2,Table1[Genre Group])))*
(IF(B3="",1,ISNUMBER(SEARCH(B3,Table1[Genre Group]))))*
(IF(B4="",1,ISNUMBER(SEARCH(B4,Table1[Top 5 Actors]))))*
(IF(B5="",1,Table1[Main Director]=B5)),"")
Can 2 more criteria be added to filter movies? This should be "AND" condition so that all criteria apply.
Thank you for your help
Bookmarks