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