Hi Everyone! I have this formula that works fine: =SORT(FILTER(A5:B536;C5:C536="X");1;-1)
Now, I'm trying to add one more criteria and I thought this one would do: =SORT(FILTER(A5:B536;(C5:C536="X")+(C5:C536="Y");1;-1)
Basically, I am trying to get the results returning not only "X" as in the first formula, but also "Y"
I'm getting a "too many arguments" error!
Now, I'm trying to add one more criteria and I thought this one would do: =SORT(FILTER(A5:B536;(C5:C536="X")+(C5:C536="Y");1;-1)
Basically, I am trying to get the results returning not only "X" as in the first formula, but also "Y"
I'm getting a "too many arguments" error!