SORTBY function in Excel (with 6 examples) | Sorting without a single click | Excel Off The Grid.

Поділитися
Вставка
  • Опубліковано 29 жов 2024

КОМЕНТАРІ •

  • @ZdenekMoravecCZ
    @ZdenekMoravecCZ 7 місяців тому +1

    SORTBY in the FILTER's "include" argument is the magic touch. You saved me an hour ;-)

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  7 місяців тому

      It caught me out the first time. So I’m glad I could share my learnings.

  • @kebincui
    @kebincui Рік тому +1

    Very clear, systematic and organized illustration of how to use Sortby function❤👍👍

  • @bedeneol
    @bedeneol 8 місяців тому +1

    Thanks so much sir. Made simple and straight forward.

  • @jmschroen-hendriks4542
    @jmschroen-hendriks4542 3 роки тому +1

    Thank you for the good explanation.
    (Google translated)
    TIP
    > Use FILTER to show only which columns are relevant to see.
    Using FILTER () with {1,1,0,1} (english version)
    = FILTER (SORTBY (Table1, Table1 [SOLD], 1), {1 \ 1 \ 0 \ 1})
    (English / Dutch version)
    Use FILTER to show only which columns are relevant.
    Select the entire table for Sortby () and filter for SOLD for example.
    Then use the FILTER (), as in the example.
    Language version can be different {1 \ 1 \ 0 \ 1} is in English version {1,1,0,1} (with comma).
    Result: (PRICE is not visible)
    EMPL SOLD TOTAL
    Jack 3 8,85
    Belinda 3 7,56
    Tom 4 11,96
    Rack 4 10,56
    Kevin 4 12,2
    Suzie 7 19,25
    Sally 8 25,44
    David 9 22,68

  • @arakelasson832
    @arakelasson832 3 роки тому +1

    Thank you Sir,
    the presentation and explanations are crystal clear !!!
    the combination with CHOOSE is extremely useful

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  3 роки тому

      CHOOSE is one of those functions that really adds benefit in unexpected circumstances. Glad I could help :-)

    • @allenkamdyn9113
      @allenkamdyn9113 3 роки тому

      a tip: watch movies on flixzone. Me and my gf have been using them for watching lots of of movies during the lockdown.

    • @ashtonlangston4490
      @ashtonlangston4490 3 роки тому

      @Allen Kamdyn Definitely, been using flixzone} for since december myself :)

  • @Gabyi1984
    @Gabyi1984 3 роки тому +2

    very helpful and clear explanations!

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 2 роки тому +1

    Good explanation… very neat explanation sir

  • @Kamekichi486
    @Kamekichi486 3 роки тому

    Thank you so much for uploading this video! I’ve been searching for the definition of sortby function on google but I didn’t really understand them.. after watching your video, I understood!! You are a star 😆

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

    Good video, in Example 5, can we use SORTBY after the result is fetched by FILTER to overcome the problem.

  • @ElJoeytv
    @ElJoeytv 2 роки тому

    Greats videos... How do I sort data from a table located on a different sheet?

  • @SamirHabib
    @SamirHabib 2 роки тому +1

    Thank you man!

  • @danya4460
    @danya4460 4 роки тому +1

    very pleasant voice!

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  4 роки тому +1

      That's very kind of you to say. Thank You :-)

    • @danya4460
      @danya4460 4 роки тому

      @@ExcelOffTheGrid Thank you for the video, great quality and very helpful!

  • @skkhan-fn9hu
    @skkhan-fn9hu 3 роки тому

    Sortby

  • @rajushah7746
    @rajushah7746 3 роки тому

    Ok

  • @mahendradhandhliya6148
    @mahendradhandhliya6148 3 роки тому +1

    Yash

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

    Sort and sortby not working 😭