Hi All
I have racked my brains on how to sort cells by Upper and Lower case words
Eg: ANT, Bird, Cat, DOG, Eagle
When i sort the cells i want the results to be either all Upper case words forst and then Lower case words, or vice vera.
ANT
DOG
Bird
Cat
Eagle
Hope this makes sense!
EDIT: Formula removed. DO provided a more efficient formula below.
Last edited by Palmetto; 08-20-2010 at 09:46 AM. Reason: remove formula
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Using your specific examples you could equally use:
B1: =EXACT(A1,UPPER(A1))
copied down
Sort by B and then A as appropriate
Last edited by DonkeyOte; 08-20-2010 at 03:45 AM. Reason: edit: reworded
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks