Dynamic filters

[VickiS]

Hello, I have created dynamic filters to present one set of results from a data set. I have 3 filters, currently the results are only generated when there is a selection in all 3 filters. But I would like the results to be generated even when there is just one filter populated. So for example, if filter 2 & 3 are blank, still present results of filter 1. Or if filter 3 is blank, I would still want the filter 1 & 2 results to show.
Current formula I am using that is giving me the results for all 3 filters when they all have values:
=FILTER('All sequences data'!$A$2:$E$36,('All sequences data'!$B2:$B36=B10)*('All sequences data'!$C2:$C36=D10)*('All sequences data'!$D2:$D36=F10))

 

[Fluff]

Hi & welcome to MrExcel.
How about

=FILTER('All sequences data'!$A$2:$E$36,(if(b10="",1,'All sequences data'!$B2:$B36=B10))*(if(d10="",1,'All sequences data'!$C2:$C36=D10))*(if(f10="",1,'All sequences data'!$D2:$D36=F10)))

 

[VickiS]

Hi & welcome to MrExcel.
How about

=FILTER('All sequences data'!$A$2:$E$36,(if(b10="",1,'All sequences data'!$B2:$B36=B10))*(if(d10="",1,'All sequences data'!$C2:$C36=D10))*(if(f10="",1,'All sequences data'!$D2:$D36=F10)))

This seems to have done it! Thank you so much - so happy to have found this forum

 

[Fluff]

You're welcome & thanks for the feedback.