( by Nighthound )
I have a list of text entries in a column that I wish to sort in case-sensitive ascending order, with capital letters before small letters.
Your desired result could be achieved in many ways, but the easiest and according to me the best way is to have a custom function.
Custom function means you have to built the function of your own in the scripts. And I have coded a script, and here it is:
if (arguments.length < 1)
return "#NA Please input range to sort";
else if (arguments.length > 1)
return "#NA Input Can't be more than one arguement";
else if(arguments.length == 1)
Have a look at the following screenshot:
Now put the formula as:
(for the example shown above in the screenshot).
And If you are not much familiar with scripts then check out the following link:
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.