Forum Discussion
Custom Sort not Working
I am trying to do a custom sort for an Excel class I am taking in college. The instructor demonstrates doing a custom sort. However, when I try to duplicate what he is doing, Excel 365 isn't doing it...
In the sample file the custom sort works according to the settings. The data for year 2006 is sorted in ascending order and the region is sorted A to Z. For example for year 2006 there are 3 entries for 119 and the region is sorted "Northeast", "Northeast" and "Southeast" which is in perfect order from A to Z. For the values 96 and 124 there are 2 entries each and they are sorted "Northeast" and "West" from A to Z.