How to use 2 expressions togeather: SELECT and

[Joshuamwkeller]

To choose certain rows from another table to be available in a EnumList I am using SELECT in Data Validity, in Valid If.

SELECT(Knowledge Base[Description],[Available in HLC 7]="Yes",True)

I also want this same list to appear in alphabetic order in my EnumList.  How can this be done?  Can ORDERBY be used along with this expressions some way?