QUERY Course for Google SHEETS - Lesson 3 - Sorting with ORDER BY
Вставка
- Опубліковано 12 вер 2024
- In this video we learn how to sort our tables with the QUERY function and, specifically, with the ORDER BY command.
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheet...
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheet...
➤Webpage: practicalsheet...
➤Newsletter: practicalsheet...
➤Telegram: practicalsheet...
➤Facebook: practicalsheet...
➤Twitter: practicalsheet...
Any suggestion, question or insights, feel free to comment below
Thank you. I was looking to sort on a query and was stuck. This helped. Thanks a lot
Excellent!
Spot on, gracius
Thank you!
YESSSSSS THATS EXACTLY WHAT I NEEDED!!!
Excellent!
Thanks. I'm glad you showed the trick of "WHERE A IS NOT NULL" - I was having that problem of empty rows.
Excellent
It is a very common case
Regards!
fantastic 🤩
Thank you!
How i can order by date if my date in this format dd.mm.yyyy?
Did you solve this? I have the same problem
Does Sheets recognize your date column as a date? or as a text. If you order it using order by, it orders alphabetically?
Kind Regards
Please tag me I’m trying to sort with dropdown so when I change a Dropbox it moves the entire row up or down based on column and where it is.
Hi!
I don´t understand fully what you want to achieve
Could you explain further?
Kind Regards
is there a way to auto sort columns without the need to copy the whole table? i get market data, and its sorted from oldest to most recent date. its no problem to sort it by recent date, as thats just 2 extra columns, but i have like 50 other columns that i would like to move with it, so the recent date is always at the top, and the rest moves down day by day, as i need to input a lot of data into the recent date cells...