— CAN YOU SOLVE THIS - EXCEL CHALLENGE 129 —
(Solutions in any language are also welcome for Excel Challenges)
We had a sorting challenge recently.
EXCEL CHALLENGE 116 - https://lnkd.in/d_EkWrBx
Now this time, sorting rules are different unlike Challenge 116.
Sort the given strings with following rule
- a and A will be sorted before b and B.
- a is sorted before A
- Digits are sorted last.
In essence, the sorting key is “aAbBcCdD…yYzZ0123456789”
Post answers in Comment.
(Your formula need not be a single formula. You can write multiple formulas to arrive at a solution. Also your formula need not be different from others as long as you have worked out your formula independently)
Download Practice File - https://lnkd.in/dWstgdAN
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excel BI LinkedIn Posrt