- slide 1 of 9
As an example, say you want to sort a list of products based on measured effectiveness. The problem is the effectiveness is described as Low, Medium or High. Sorting using conventional options results in the illogical order High-Low-Medium or Medium-Low-High. By configuring a custom list for sorting, you instruct Excel to use the order you designate.
Highlight the data you want sorted.