Sort multiple criteria combined with filter

[ausswe]

Hi,
I've been trying to get my head around how to sort (by multiple criteria) in a filter but can't seem to get it to work.
The original filter also included CHOOSECOLS but I have tried to remove that to troubleshoot but without success.

The filter (pulling data from a sheet named DATA) is working on its own:
FILTER(DATA;DATA[YEAR]=A7;"No results")

I have tried to use SORTBY but I keep getting #VALUE (found a post suggesting to use SORT BY as someting like this: SORTBY(A5:D14;D5:D14;1;C5:C14;-1) and then I found a post suggesting that SORTBY should come after the inital filter:
FILTER(SORTBY(DATA;DATA[[#All];[YEAR]]=A7;"No results");DATA[[#All];[YEAR]];1;DATA[[#All];[MODEL]];1)
This gives me the error that I have too many arguments.
I have tried to change order of the arguments but have been unsuccessful.

Checking if anyone would have any suggestions on what I'm missing.

Thanks in advance.

 

[Fluff]

How about

=sort(FILTER(DATA;DATA[YEAR]=A7;"No results");{4\3},{-1\1})

 

[ausswe]

How about

=sort(FILTER(DATA;DATA[YEAR]=A7;"No results");{4\3},{-1\1})

Thanks Fluff - that seems to work!
I haven't come across that one when I've been searching.

I tried to replace column 4 and 3 with NamedRanges that I use to make it easier for users to sort the data but that doesn't seem to work:

=sort(FILTER(DATA;DATA[YEAR]=A7;"No results");{Sort1\Sort2},{-1\1})

That is something that might not be an option when using {4\3} perhaps?

 

[Fluff]

You cannot use named ranges in an array constant, but try

=sort(FILTER(DATA;DATA[YEAR]=A7;"No results");hstack(Sort1;Sort2),{-1\1})

 

[ausswe]

Thank you for your help Fluff - that seems to work fine!
Now I will read up on HSTACK!

 

[Fluff]

You're welcome & thanks for the feedback.