Excel SORT and SORTBY Functions - 3 Examples of Excel Sort Formulas

Share this & earn $10
Computergaga
Published at : 04 Nov 2020
3040 views
93
1

In this video, we see three examples of the SORT and SORTBY functions automatically sorting formula results.

These functions are incredibly useful. Excel has been crying out for these sort formula for years.

The examples in this video go from basic to complex.

Download the Excel file to practise - https://www.computergaga.com/excel/files/365-functions-sort-and-sortby.xlsx

New to these dynamic arrays formulas? Watch this - https://youtu.be/X2ybRZbvR5k

Excel FILTER Function - Is this the Best Excel Function? - https://youtu.be/kdl3mNEyIRE

Find more great free tutorials at;
https://www.computergaga.com

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► https://bit.ly/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1
excel sort functionexcel sortby functionmicrosoft excel

The surprising pattern behind color names around the world

The surprising pattern behind color names around the world

(Vikings) Ragnar Lothbrok || The Choice

(Vikings) Ragnar Lothbrok || The Choice

Аудиокнига «Ключ к подсознанию» | Эзотерика [NikОsho]

Аудиокнига «Ключ к подсознанию» | Эзотерика [NikОsho]

K391, Alan Walker, Tungevaag & Mangoo - Play

K391, Alan Walker, Tungevaag & Mangoo - Play

ZWIFT RACE with Elite Sterzo Smart // I'll probably get dropped in the C cat on Downtown Dolphin

ZWIFT RACE with Elite Sterzo Smart // I'll probably get dropped in the C cat on Downtown Dolphin

Donna Marie - Think Twice (Official Version)

Donna Marie - Think Twice (Official Version)

Chameleon Circuit - Teenage Rebel

Chameleon Circuit - Teenage Rebel

cum sa faci un circular de masa part 1 (how to make table saw)

cum sa faci un circular de masa part 1 (how to make table saw)

Probability Distribution Functions (PMF, PDF, CDF)

Probability Distribution Functions (PMF, PDF, CDF)

PinkSweat$ - Live from My Den

PinkSweat$ - Live from My Den

Moog Subsequent 37 Sounds

Moog Subsequent 37 Sounds

Study With Me LIVE DISCORD STUDYROOM ACCESS | Forest🎄 | Pomodoro⏱

Study With Me LIVE DISCORD STUDYROOM ACCESS | Forest🎄 | Pomodoro⏱

'All Summer Long'-Unsurpassed Masters-The Beach Boys

'All Summer Long'-Unsurpassed Masters-The Beach Boys

#EasyMoneyPlays | Best Penny Stocks 🔥🔥🔥 | Stock Lingo: Savings

#EasyMoneyPlays | Best Penny Stocks 🔥🔥🔥 | Stock Lingo: Savings

Down Under

Down Under

LETHAL JATTI (Official Video) | Harpi Gill ft. Mista Baaz | Ajay Sarkaria | New Punjabi Songs 2020

LETHAL JATTI (Official Video) | Harpi Gill ft. Mista Baaz | Ajay Sarkaria | New Punjabi Songs 2020

Live : Hare Rama Hare Krishna | Shri krishna | Shri Krishna Govind Hare Murari | Krishna bhajan

Live : Hare Rama Hare Krishna | Shri krishna | Shri Krishna Govind Hare Murari | Krishna bhajan

32nd America's Cup Race 3 SUI vs. NZL | AMERICA'S CUP

32nd America's Cup Race 3 SUI vs. NZL | AMERICA'S CUP

Adele at the BBC: When Adele wasn't Adele... but was Jenny!

Adele at the BBC: When Adele wasn't Adele... but was Jenny!

COVID-19 economic recovery requires sustained spending, Freeland says

COVID-19 economic recovery requires sustained spending, Freeland says

Exploring the Cincinnati Mills Mall - Abandoned Yet Still Open

Exploring the Cincinnati Mills Mall - Abandoned Yet Still Open

CSEP Paper 0: Let's just print more money? Modern Monetary Theory and its Critics

CSEP Paper 0: Let's just print more money? Modern Monetary Theory and its Critics

SKINCARE PLUS MAKEUP TRANSFORMATION| NO MAKEUP MAKEUP WITH A BUZZ| DRAMATIC 25MM 3D MINK| JWILLSCOOL

SKINCARE PLUS MAKEUP TRANSFORMATION| NO MAKEUP MAKEUP WITH A BUZZ| DRAMATIC 25MM 3D MINK| JWILLSCOOL

Impossible To Resist

Impossible To Resist

Pakistan earthquake causes new island to appear

Pakistan earthquake causes new island to appear

Lipolight (Be sure you watch from 40 seconds)

Lipolight (Be sure you watch from 40 seconds)

Crazy Frog - Everyone [2019K Remake]

Crazy Frog - Everyone [2019K Remake]

How to Flesh a Deer Hide

How to Flesh a Deer Hide

Principal component analysis

Principal component analysis

Grow 1-2 inches Taller Naturally | Neck Exercises

Grow 1-2 inches Taller Naturally | Neck Exercises

Sunsrise Meadow-Paint and Stitch Tutorial (WEST MOON)

Sunsrise Meadow-Paint and Stitch Tutorial (WEST MOON)

My Simple Secret to Profitably Trade Currencies

My Simple Secret to Profitably Trade Currencies

프라이머리(Primary) - '입장정리 (Feat. 최자, Simon D)' M/V

프라이머리(Primary) - '입장정리 (Feat. 최자, Simon D)' M/V

Stupidity At Its Best | FailArmy

Stupidity At Its Best | FailArmy

6 LAGU COVER DANGDUT PILIHAN | DECKY RYAN / DI JAMIN BIKIN BAPER

6 LAGU COVER DANGDUT PILIHAN | DECKY RYAN / DI JAMIN BIKIN BAPER

Should The US Be Considered A Democracy?

Should The US Be Considered A Democracy?

ESL - Teaching English in China: Grade 1 ( Demo lesson)

ESL - Teaching English in China: Grade 1 ( Demo lesson)

Learn with Little Baby Bum | Nursery Rhymes Gone Wrong | Nursery Rhymes for Babies | Songs for Kids

Learn with Little Baby Bum | Nursery Rhymes Gone Wrong | Nursery Rhymes for Babies | Songs for Kids

Difference Between Ethics and Morals - Ethics vs Morals

Difference Between Ethics and Morals - Ethics vs Morals

Deploy a Customized Windows 10 Start Menu with MDT 2013!

Deploy a Customized Windows 10 Start Menu with MDT 2013!

There's No Such Thing As Out Of Shape

There's No Such Thing As Out Of Shape

Panic! At The Disco - One Of The Drunks (Official Audio)

Panic! At The Disco - One Of The Drunks (Official Audio)

Chris Young - Tomorrow (Official Video)

Chris Young - Tomorrow (Official Video)

The 60FPS Console Player in Your Recommended 😍

The 60FPS Console Player in Your Recommended 😍

Quiet - Kurloz

Quiet - Kurloz

War for the Study Room

War for the Study Room

Bushes & Shrubs

Bushes & Shrubs

Jax Jones - Instruction ft. Demi Lovato, Stefflon Don (Lyrics)

Jax Jones - Instruction ft. Demi Lovato, Stefflon Don (Lyrics)

"5 Best Ways To Utilize This Free Time Period"

"5 Best Ways To Utilize This Free Time Period"