Show data by default without hitting Reapply in Sort&Filter menu

[OlllieMollie92]

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 want to automatically display "No" and "Unknown" responses. 

Right now, I have to click on the Filter and Hit OK every time a "No" or "Uknown" response is added in sheet 1.

Is there a solution for the "No" and "Unknown" answers to be automatically displayed in Sheet 2 right after filling them in Sheet 1? 

Thank you in advance!

[#2]

@OlllieMollie92 

Do you have Microsoft 365 or Office 2021? If so, you can use the FILTER function 

[#3]

@Hans Vogelaar 

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..

[#4 · Accepted solution]

@OlllieMollie92 

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"), "")

[#5]

Thank you, Hans! I have applied the formula with success.