helpneeded2
Board Regular
- Joined
- Jun 25, 2021
- Messages
- 110
- Office Version
- 365
- Platform
- Windows
I am new to the FILTER function and I have not been able to find a way to filter for data with multiple conditions.
Here is the syntax of my current filter, which does not appear to be correct syntax:
I am trying to filter my data only if 1 of these 2 conditions are met:
- Column AO data is = "Not Rated" (OR)
- Column AM is "No" AND Column AO is "High", "Medium" or "Low"
Can someone please advise if this is possible with the filter function.
Thank you.
Here is the syntax of my current filter, which does not appear to be correct syntax:
Code:
=FILTER(ALL!A2:BV26415,OR(ALL!AO2:AO26415="Not Rated",AND(ALL!AM2:AM26415="No",OR(ALL!AO2:AO26415="High",ALL!AO2:AO26415="Medium",ALL!AO2:AO26415="Low"))))
I am trying to filter my data only if 1 of these 2 conditions are met:
- Column AO data is = "Not Rated" (OR)
- Column AM is "No" AND Column AO is "High", "Medium" or "Low"
Can someone please advise if this is possible with the filter function.
Thank you.