Forum Discussion
Filter multiple criteria or all
Hi, I have set up a table of data and in one column there are 2 different criteria. I have created a filter to show results between 2 dates and based on one or the other criteria in the column. Wha...
In N3:
=FILTER(FYFunded_Deals,IF($O$3="Select All",1,(FYFunded_Deals[CP ID]=$O$3))*(FYFunded_Deals[Settlement Date]>=$Q$3)*(FYFunded_Deals[Settlement Date]<=$R$3))
