How to Sort in Excel Using 2 Columns in a Formula - Search Videos

Sort by two columns

Sort by two columns

To sort by two columns, you can use the SORTBY function. In the example shown, data is sorted first by the Group column in ascending order, then by the Score column in descending order. The formula in F5 is: =SORTBY(B5:D14,D5:D14,1,C5:C14,-1) The result is data sorted by group, then by score, with highest scores appearing first.

Excel Sorting Tricks

Excel Sorting Trick in 10 Sec ⚡ | Ascending & Descending Shortcut Key 🔥 #excel #exceltips #shorts

Excel Sorting Trick in 10 Sec ⚡ | Ascending & Descending Shortcut Key 🔥 #excel #exceltips #shorts

YouTubeGyansarovar classes

🚨 Excel Hack You’ve Never Heard of! Sort by Color in 10 Seconds 🤯 #shortsfeed #excel #viral

🚨 Excel Hack You’ve Never Heard of! Sort by Color in 10 Seconds 🤯 #shortsfeed #excel #viral

YouTubeLearn With KPM

570 views1 month ago

Sort By Color in Excel | How to Sort Excel Data By Cell Color #shorts #excel #filter

Sort By Color in Excel | How to Sort Excel Data By Cell Color #shorts #excel #filter

YouTubeLearn Fast Everything

802 views3 weeks ago

Top videos

Sort Multiple Columns with Formula - Excel & Google Sheets

Sort Multiple Columns with Formula - Excel & Google Sheets

automateexcel.com

How to do Multiple Level Data Sorting in Excel

How to do Multiple Level Data Sorting in Excel

SORT Function

Excel Filter and Sort

How to Sort and Filter Your Data in Excel

How to Sort and Filter Your Data in Excel

YouTubeSimply Excel

59.5K viewsMar 30, 2021

Excel for Beginners #6 - Sorting And Filtering Made Easy

Excel for Beginners #6 - Sorting And Filtering Made Easy

YouTubeThe Excel Hub

143 views4 months ago

Excel Sorting and Filtering Data

Excel Sorting and Filtering Data

YouTubeThe Organic Chemistry Tutor

1M viewsJun 7, 2018

Sort Multiple Columns with Formula - Excel & Google Sheets

Sort Multiple Columns with Formula - Excel & Google Sheets

automateexcel.com

How to do Multiple Level Data Sorting in Excel

How to do Multiple Level Data Sorting in Excel

SORT Function

SORT Function

UNIQUE with non-adjacent columns

UNIQUE with non-adjacent columns

FILTER Formula to Return Non-Adjacent Columns in Any Order - Excel Campus

FILTER Formula to Return Non-Adjacent Columns in Any Order - Excel Campus

excelcampus.com

Filter exclude blank values

Filter exclude blank values

INDEX and MATCH with multiple criteria

INDEX and MATCH with multiple criteria

Excel Dynamic Arrays (How they will change EVERYTHING!)

Excel Dynamic Arrays (How they will change EVERYTHING!)

783.9K viewsOct 18, 2018

YouTubeLeila Gharani

Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

463.5K viewsApr 21, 2017

YouTubeLeila Gharani

How to compare two columns using VLOOKUP in Microsoft Excel?

How to compare two columns using VLOOKUP in Microsoft Excel?

75.4K viewsJun 13, 2016

YouTubeBeing Skilled

How To Use "Text To Columns" In Excel

How To Use "Text To Columns" In Excel

298.1K viewsMay 6, 2014

YouTubeBusiness Insider

Excel Sort Column by Numbers in Ascending/Descending Order (2020)

Excel Sort Column by Numbers in Ascending/Descending Order (2020)

911.3K viewsDec 1, 2020

YouTubeLeon Renner

Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704.

Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704.

136.8K viewsNov 27, 2020

YouTubeexcelisfun

How to Group by Rows and Columns in Excel

How to Group by Rows and Columns in Excel

113K viewsAug 12, 2024

YouTubeTeacher's Tech

How to Compare Two Columns in Excel | Show Matches & Differences

How to Compare Two Columns in Excel | Show Matches & Differences

71.6K viewsMar 28, 2025

YouTubeChester Tugwell

How to Make Multiple Sortable Headings in Excel

How to Make Multiple Sortable Headings in Excel

11.4K viewsOct 20, 2023

YouTubeExcelDemy

How to Find Duplicate Rows using Columns as Criteria | 2 Examples

How to Find Duplicate Rows using Columns as Criteria | 2 Examples

11.5K viewsMar 6, 2024

YouTubeJopa Excel

Real-Time Multi-Column Data Search Box in Excel with FILTER function [Part 2]

Real-Time Multi-Column Data Search Box in Excel with FILTER function [Part 2]

65.2K viewsMay 19, 2020

YouTubeThe Office Lab

The Excel TRANSPOSE Function

The Excel TRANSPOSE Function

469.4K viewsDec 7, 2020

YouTubeTechnology for Teachers and Students

Excel Split Names Tutorial

Excel Split Names Tutorial

593.2K viewsOct 16, 2017

YouTubeTechnology for Teachers and Students

How to Sort Alphabetically in Excel

How to Sort Alphabetically in Excel

133K viewsApr 15, 2020

YouTubeHow-to Videos

Excel Sorting and Filtering Data

Excel Sorting and Filtering Data

1M viewsJun 7, 2018

YouTubeThe Organic Chemistry Tutor

How to Use VLOOKUP to Compare Two Lists

How to Use VLOOKUP to Compare Two Lists

1.2M viewsApr 28, 2021

YouTubeSimon Sez IT

How to Use the FILTER Function in Google Sheets | Multiple Columns

How to Use the FILTER Function in Google Sheets | Multiple Columns

388.6K viewsNov 24, 2020

YouTubeLeila Gharani

HOW TO: compare two columns in Excel using VLOOKUP

HOW TO: compare two columns in Excel using VLOOKUP

140.3K viewsSep 19, 2019

YouTubeExcel at Work

Excel Conditional Formatting - Multiple Columns - 3 Examples

Excel Conditional Formatting - Multiple Columns - 3 Examples

78.8K viewsApr 4, 2019

YouTubeComputergaga

Multiple Level Sub-Total in Excel

Multiple Level Sub-Total in Excel

119K viewsMar 27, 2015

YouTubeRich Kerr

How to Sort and Filter Data in Excel 2016

How to Sort and Filter Data in Excel 2016

150.9K viewsMar 5, 2018

YouTubeKnowledgeCity

Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting

Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting

122K viewsSep 1, 2021

YouTubeChris Menard

See more