I need to sort grades in order, e.g., A, A-, B+, B, B-, C+, C, C-, etc.
Normal sort places has the order B, B-, B+, and using the custom list with the grades in perfect order results in, A-, B+, B-, C+,C-, A, B, C, D, F. It somehow places all +/- grades first and then the others.
Is there any workaround? I would expect a custom list to dictate the order of sorting.
I'm using Excel for Mac 2011.
Thanks,
Chazzs