How to sort a column based on specific text in Google Sheet

Question

I have the following:

=sort(filter('CASES LIST'!C:R,('CASES LIST'!Q:Q="admission")+('CASES LIST'!Q:Q="pending")+('CASES LIST'!Q:Q="PCI")),16,true)

but I want to sort in the following sequence:

Pending first
admission second
PCI third

Answer 1

Please use the following query formula (adjusting ranges to your needs), instead of the filter one you already use.

=QUERY(sort(P1:R,match(Q1:Q,{"Pending","admission","PCI"},0),TRUE), 
               "where Col2 matches 'admission|PCI|pending' ",0)

Functions used:

• QUERY
• SORT
• MATCH