Custom Sort Order In Numbers

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.

Comments: One Response to “Custom Sort Order In Numbers”

    Jeff Harmed
    2 weeks 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.

Leave a New Comment Related to "Custom Sort Order In Numbers"

0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)