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

Sorting is not always about ascending, descending or alphabetical order. You may need to use different criteria. You may also want to consider the uppercase and lowercase of the same letter as different characters in the sorting order. This video shows an example of how we can take advantage of Excel’s built-in functionalities to solve data sorting challenges.
#excel #exceltraining #solveandexcel #excelautomation #microsoftexcel #msexcel

________________________________________________________

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
___________________________________________________________________

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer

Twitter: @celia_excel

Instagram: @solveandexcel


#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA

#microsoft365 #microsoft #toronto #torontobusiness #wit #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #powerquerytraining #powerqueryeditor #worksmarternotharder #canada #msexceltraining #microsoftexceltips

[GopiNath-fply]

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

[wayneedmondson]

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

[JDL]

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

[triplejb]

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.