Custom Sort Order In Numbers

macmost.com/e-3138 While it is easy to sort by numerical or alphabetical values, there is no simple way to sort with a custom order like High, Medium and Low. But you can use simple SEARCH or MATCH formulas to do a custom sort if you need it.
FOLLOW MACMOST FOR NEW TUTORIALS
▶︎ Subscribe here at UA-cam - macmost.com/j-youtube (And hit the 🔔)
FREE EMAIL NEWSLETTER
▶︎ See what's new each week and more - macmost.com/newsletter 📬
▶︎ Per-Video Email Notifications - macmost.com/ytn 📆
SUPPORT MACMOST AT PATREON
▶︎ macmost.com/patreon ❤️
00:00 Intro
01:17 Adding a Sort Order Column
02:06 Custom Sort With the SEARCH Function
03:54 Hide the Sort Order Column
04:31 Problems With the SEARCH Function Method
05:17 Custom Sort With the MATCH Function
07:45 Sort By Multiple Rows
#macmost #mactutorial

[@alanmclean1399]

That was really useful, as it had a quick, simple search and a more comprehensive method.

[@mamalovesthebeach437]

I'm using numbers for a client list. I like your idea of a sort column to prioritize callbacks on specific clients. Thank you, Gary!

[@peazmo]

I've been using this for almost a decade already except the "custom" sort using MATCH function. This tutorial is very helpful. Thanks much Sir Garry.

[@peterc2248]

I use this a lot here in the UK where the financial year starts in April and the usual date sorts put January first - very useful

[@Trackhoe075]

Thanks Gary this is so useful

[@thehman2007]

Another useful video.

[@desertpatient]

Thanks bunches

[@stephenbridges2791]

I would not have thought to use "Search". Cool.

[@bevintx5440]

Yes, that’s very useful!

[@AricBolf]

This may not apply to this video, however…i found a quark with MATCH function. I have a second table with a list of stock prices from $11 to $18. I use the index and match functions to find items in the second table. However, if i search for $10, it’s outside the range of $11 to $18, so it throws an error because i was using ‘find largest value’. I had to switch it to ‘find smallest value’ for searches that could potentially fall under $11. I continue using ‘find largest value’ for searches potentially above $18. I hope i explained that ok. Just wanted to pass this along.

[@loisskiathitis8926]

A very useful and informative video tutorial today! Thank you, Gary! 👏🏻❤️

[@garrysingh4484]

Hey 👋
My Mac (Apple Silicon), App Store doesn't show available updates, Using App Stroe default settings, No Changes but recently it has stopped showing available updates, tried clearing cache but not successful.
Few days earlier i was just checking few apps, on app store then came to Apple Keynote, Pages & noticed there's an update available for Pages. Keynote but if i go to the Available updates section in the App Store, these updates are not available.
Seems like updates only visible within the App Section not in the Available updates section.
Any fix ???
Maybe if you can make a video to fix this problem

[@macmost]

I don't know what would cause that problem, sorry. Did you try Command+R on the App Store updates screen?

[@garrysingh4484]

@@macmost Just tried Reload Page (Command R) - Updates appeared !!!
Thanks 👍👍👍

[@williamhalstediq]

Can you please make a tutorial on mapping controller keys on Macos esp. 8bit zero 2 , i used kanarban app and even bought an app from appstore and none worked for me . I use the controller with Anki & remnote for flashcards. I tried other apps and many different fixes but none worked very well , idk why it’s such a hassle to do. I would really appreciate it ❤

[@macmost]

Controllers, like game controllers? If they don't come with software to do it, I would try using Keyboard Maestro to customize them. But I've never tried.

[@williamhalstediq]

@@macmost I’ll try it , tysm