Forum Discussion

phd0k's avatar
phd0k
Copper Contributor
Apr 20, 2023

FILTER with multiple conditions and exclude #NA

Hello, I will try to keep it simple.   I have a filter that brings up a select data from a drop down menu. These rows can be between 1-20 in length with the =FILTER(Example!M:M,(Example!B:B=$B$5)*(...
excel
Formulas and Functions
phd0k's avatar
phd0k
Copper Contributor
Apr 20, 2023
the fix was =IFERROR(FILTER(Example!M:M,(Example!B:B=$B$5)*(Example!G:G=C5)), "")

Resources