Sunday, July 7, 2013

yogi_Perform Case-Sensitive Sort Column A -- UpperCase before LowerCase In Ascending Order

                                          Google Spreadsheet   Post  #1277
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 07, 2013
user Nighthound (http://productforums.google.com/forum/?zx=6iirw4vwjgk#!category-topic/docs/spreadsheets/B2GDRj9PKK8)
Sort in case-sensitive ascending order
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.

For example, I want to sort:

Abcd
ASDF
aaaa

and get:

ASDF
Abcd
aaaa

However, Google Sheets ignores case when sorting in ascending order and gives this result:

aaaa
Abcd
ASDF

 What can I do to achieve my desired result?
---
Here is the example Google Sheets document. Basically, I want to sort the items in column A in the order as shown in column C. Using the built-in sort function produces the result in column B, which is essentially a case-insensitive sort.

---------------------------------------------------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment