I created a pivot table from a list containing 3 character IDs, then used the Pivot Table field pulldown to sort it.
The resulting sorted list looks like this:
Looks like Pivot Table sort recognises 3 character abbreviations for
- The day of the week
- A quarter given as the initial letter of the month
And decides to sort them into (some kind of mangled) time sequence and place them before the unrecognised 3-character IDs!
And I can’t find a way to make it do a proper sort!
Any ideas how you can make Excel do this in a not-so-clever but more sensible way?
Thanks to Debra, Alastair and Rory for telling me how to do it.