Custom Sort Order – Google Sheets Tutorial

Published: 01 November 2025
on channel: Spencer Farris
1,619
12

The sort options in Google Sheets – the SORT() function, the Data options, and column sorts – only allow alphabetical sorts, either ascending or descending.

However, a custom sort order is possible using a range to define the sort order, a MATCH() function in a helper column to find the correct ranking of each item, and then sorting on that helper column.

https://docs.google.com/spreadsheets/...


Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

https://www.facebook.com/profile.php?...
https://x.com/SpencersSheets
https://bsky.app/profile/spencersshee...
  / reels  

I use Bandicam to record, Clipchamp to edit, and a Blue Yeti microphone

Donate on Paypal: spencer.farris@gmail.com


On this page of the site you can watch the video online Custom Sort Order – Google Sheets Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Spencer Farris 01 November 2025, share the link with friends and acquaintances, this video has already been watched 1,619 times on youtube and it was liked by 12 viewers. Enjoy your viewing!