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

[@ZdenekMoravecCZ]

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

[@ExcelOffTheGrid]

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

[@kebincui]

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

[@ExcelOffTheGrid]

Thanks Kebin 👍

[@bedeneol]

Thanks so much sir. Made simple and straight forward.

[@jmschroen-hendriks4542]

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

[@ExcelOffTheGrid]

Great tip - thank you for sharing it 👍

[@arakelasson832]

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

[@ExcelOffTheGrid]

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

[@allenkamdyn9113]

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

[@ashtonlangston4490]

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

[@Gabyi1984]

very helpful and clear explanations!

[@ExcelOffTheGrid]

Glad it was helpful! :-)

[@pandharinathjoshi6565]

Good explanation… very neat explanation sir

[@ExcelOffTheGrid]

Thank You 😀

[@Kamekichi486]

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 😆

[@ExcelOffTheGrid]

Thanks Emma - I appreciate that :-)

[@sachinrv1]

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

[@ElJoeytv]

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

[@SamirHabib]

Thank you man!

[@ExcelOffTheGrid]

No problem!

[@danya4460]

very pleasant voice!

[@ExcelOffTheGrid]

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

[@danya4460]

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

[@skkhan-fn9hu]

Sortby

[@rajushah7746]

Ok

[@mahendradhandhliya6148]

Yash

[@noushadvemmully]

Sort and sortby not working 😭

[@ExcelOffTheGrid]

What version of Excel are you using?

[@noushadvemmully]

@@ExcelOffTheGrid 2013

[@ExcelOffTheGrid]

@@noushadvemmully
SORTBY is only available in Excel 2021 and Excel 365.