Forum Discussion
robwill100
Dec 13, 2022Brass Contributor
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...
HansVogelaar
Dec 13, 2022MVP
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))
- robwill100Dec 14, 2022Brass Contributor