Filter function inner problem

[Amin3507]

I have noticed that the filter function has a problem with combining "and" and "or" conditions. meaning if I want to use or condition from the same column so that will work fine. The problem is if I want to use in one condition "and" (2 values from 2 different columns) and combine that with "or" - for example:

filter(A:A, (B:B=2023,C:C>5)+(B:B=2024) - I want to get the values in Col A where or (ColB=2023 and values in Col C are greater then  5) or values in Col B =2024. I will not be able to get the required values. 

[icrew]

Perhaps the Query function might work better in this case? See https://support.google.com/docs/answer/3093343?hl=en and https://developers.google.com/chart/interactive/docs/querylanguage for more details.