Forum Discussion
Solved
Show data by default without hitting Reapply in Sort&Filter menu
Hello, Could you please help me out with automating a filter as follows. 1. I populate data into Sheet 1, choosing a Response from column D. It can be Yes, Unknown, No. 2. In sheet 2 I ...
You should refer to the sheet in the conditions too, and use + instead of *:
=FILTER(Worksheet!B2:D1000, (Worksheet!D2:D1000="No")+Worksheet!D2:D1000="Unknown"), "")
Do you have Microsoft 365 or Office 2021? If so, you can use the FILTER function
Thank you for reaching out so quickly - much appreciated!
I have an 0365 license...
I tried using the Filter function, however, I am sure I am missing something...
I only need to bring and refresh automatically the questions answered with No and Unknown..
You should refer to the sheet in the conditions too, and use + instead of *:
=FILTER(Worksheet!B2:D1000, (Worksheet!D2:D1000="No")+Worksheet!D2:D1000="Unknown"), "")
- Thank you, Hans! I have applied the formula with success.