Filter ORDERBY after SELECT query ?

[Stephane_Stepha]

Hello,

Please could you help me to resolv this problem.

I created à formula (Valid if in a column) to get a drop-down list of agencies thatis in another datasheet table with conditions like this :

SELECT(List [Agence],

OR([Situation]="FR",[Situation]="ESP",[Situation]="UK",[Situation]="DE"))

Now, how can I organize in ascenging the results [Agence] ?

I tried some quiery with ORDERBY combinaison but all return failed.

By advance thank you for your reply.

Regards

[diogolupcosta]

SORT(

SELECT(List [Agence],

OR([Situation]="FR",[Situation]="ESP",[Situation]="UK",[Situation]="DE"))

)

[Stephane_Stepha · Accepted solution]

Simply !!!

Thanks a lot diogolupcosta  👍