Google Sheets – How to Sort a Column Based on Specific Text

formulasgoogle sheetsgoogle-sheets-querysorting

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

Best Answer

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:

Related Solutions

Google Sheets – Filter or Sort Based on Condition

I've added the result of your question in the Google Spreadsheet you shared with us.
In the SUMMARY sheet I collected all data that fits the criterion D<>0, with the following formula:

=QUERY(DATA!A:D;"SELECT A,C,D WHERE D<>0")

I also added an ID number, for the two companies and added the column to the summary sheet. As you can see, this formula can be easily extended.

Google-sheets – Auto sort a column and auto duplicate all sheets to one sheet

Sorting a range (for example A and B columns) is a built-in function:

Select the range to be sorted
Go to Data>Sort
Specify sorting criteria.

To duplicate to another sheet, you have to first decide how wide the original ones are going to get. For example, suppose each sheet only uses five columns A:E.

Then on Sheet8 you can enter

A1 =ARRAYFORMULA(Sheet1!A:E)
G1 =ARRAYFORMULA(Sheet2!A:E)

and so on. This way, the content of Sheet1 is in columns A:E of Sheet8, the content of Sheet2 is in columns G:K, and so on.

Best Answer

Related Solutions

Google Sheets – Filter or Sort Based on Condition

Google-sheets – Auto sort a column and auto duplicate all sheets to one sheet

Related Topic