I'm working with one Spreadsheet named "geral" (General, in Portuguese), where I saved all informations and the column A saves the Names of the people. I created another sheet just to see some columns from 'Geral' Sheet, and I entered the following formula in A1 cell:
=QUERY(geral!1:994; "select A,F,L,M order by A"; 1)
. It doesn't work, but if I wrote ... order by A desc
it works well.
How can I write the query to see the data in "ABC" order, and not just descending?
Look lower down your sheet. Blanks are being sorted first.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With