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.
Want to know more about how to use Numbers on your Mac? Check out this MacMost course!
Comments: 3 Responses to “Custom Sort Order In Numbers”
Jeff Harmed
5 months ago
Nifty work. You could also use lookup and refer to another column in the reference table. If you use popups in the first table, there could be problems if popups are updated.
Rose Enney
2 months ago
I reorganized my spreadsheet and my date column disappeared. How do I get it back? Is it gone for good?
Rose: First, if you still have the document open, try simply using Undo multiple times to go back to before your mistake. Second, try using File, Revert To, to go back to a previous version before your mistake.
Leave a New Comment Related to "Custom Sort Order In Numbers"
Nifty work. You could also use lookup and refer to another column in the reference table. If you use popups in the first table, there could be problems if popups are updated.
I reorganized my spreadsheet and my date column disappeared. How do I get it back? Is it gone for good?
Rose: First, if you still have the document open, try simply using Undo multiple times to go back to before your mistake. Second, try using File, Revert To, to go back to a previous version before your mistake.