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

КОМЕНТАРІ • 16

  • @RajeshKumarPV
    @RajeshKumarPV Місяць тому +2

    Thank you. I was looking to sort on a query and was stuck. This helped. Thanks a lot

  • @camioneur
    @camioneur 2 місяці тому +1

    Spot on, gracius

  • @rafalvarezsevilla
    @rafalvarezsevilla Рік тому

    YESSSSSS THATS EXACTLY WHAT I NEEDED!!!

  • @jasonstewart7983
    @jasonstewart7983 Рік тому

    Thanks. I'm glad you showed the trick of "WHERE A IS NOT NULL" - I was having that problem of empty rows.

  • @okon1624
    @okon1624 11 місяців тому +1

    fantastic 🤩

  • @user-vd2rl3bt9k
    @user-vd2rl3bt9k 7 місяців тому +1

    How i can order by date if my date in this format dd.mm.yyyy?

    • @alexandrateixeiraf
      @alexandrateixeiraf 5 місяців тому

      Did you solve this? I have the same problem

    • @practicalsheets
      @practicalsheets  2 місяці тому

      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

  • @kipinsane1
    @kipinsane1 4 місяці тому

    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.

    • @practicalsheets
      @practicalsheets  4 місяці тому

      Hi!
      I don´t understand fully what you want to achieve
      Could you explain further?
      Kind Regards

  • @rafalvarezsevilla
    @rafalvarezsevilla Рік тому

    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...