New answers tagged sorting
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
2
The select clause identifies "Col1" and "count(Col1)". So try order by on "count(Col1)":
"select Col1, count(Col1) where Col1 != '' group by Col1 order by count(Col1) label Col1 'Name', count(Col1) 'Count'"
Top 50 recent answers are included
