How to sort data in an Excel Table following any sorting criteria - T0023

[@GopiNath-fp5ly]

Great. For small problem you take lot of effort to give a perfect solution.

[@CeliaAlvesSolveExcel]

Gopi, I guess the problem is small only to those who do not own it. 😁

[@wisecatnoroboris]

Thank you!

[@wayneedmondson1065]

Hi Celia. Nice solution! Thanks for sharing it :)) Thumbs up!!

[@triplejb5173]

How to create a sort with all uppercase first, then all lower case. i.e., AAABBBBCCCCaaaabbbbccc? Also, this is okay if you only have a single character, but what about whole words?? i.e., Abc Acd Ade Bbc Bcd Bde abc acd ade bbc bcd bde? This is the default ASCII sequence ordering, and it is annoying that Excel defaults to the more complicated mixing of upper and lower case when doing a sort; and without offering the simpler ASCII sequence sorting.

[@JDL891]

I thought Flash Fill would allow you to create a column of letters the alphabet but it doesn't work. ☹

[@CeliaAlvesSolveExcel]

I think it would be autofill instead, and it only works if you have the alphabet as one of your custom lists.